HP 3000 Manuals HP 3000 Manuals
ALLBASE/SQL Warning Messages (Cont.)
20690 MESSAGE WARNING - Table !.! has been created with a
REFERENTIAL CONSTRAINT on a table that was dropped
during the migration. (DBWARN 20690) Table !.! is
being dropped.
CAUSE A backward migration was in progress when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION If you need to recover the table, the backup
version of the DBEnvironment must be restored. If
you need to transfer this data to the target
release, use the ISQL UNLOAD EXTERNAL command.
----------------------------------------------------------------------------
20700 MESSAGE WARNING - INDEX has been defined on sixteen (16)
columns. (DBWARN 20700). Index ! defined on table
!.! is being dropped.
CAUSE In the target release, the maximum number of
columns on which an index may be defined is fifteen
(15). Functionality that is not present in the
target release has been detected.
ACTION After migration to the target release, recreate the
dropped index using fewer columns.
----------------------------------------------------------------------------
20754 MESSAGE SET NEWLOG OFF was previously issued. (DBWARN
20754)
CAUSE The current value of the NEWLOG variable is OFF, so
a START DBE NEWLOG command was not performed during
the MIGRATE command.
ACTION No action is necessary. If you want a START DBE
NEWLOG command to be performed during future
MIGRATE commands, issue a SET NEWLOG ON command.
----------------------------------------------------------------------------
22530 MESSAGE WARNING - Table !.! contains the following
columns which are not supported under the target
release of ALLBASE/SQL. (DBWARN 22530)
CAUSE A backward migration is being PREVIEWed when this
message is issued. Column types that are only
supported under the newer release of ALLBASE/SQL
are present in the user table mentioned in the
warning.
ACTION The offending columns must be eliminated or
modified to be of types supported by the target
version before a migration is attempted. If they
are not removed, then the table will be dropped
during the MIGRATE command.
----------------------------------------------------------------------------
22620 MESSAGE WARNING - Table !.! has been created using the
HASH option, which is not supported under the
target version of ALLBASE/SQL (DBWARN 22620). This
table will be dropped during the migration.
CAUSE A backward migration was PREVIEWED when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION If you need to transfer this data to the target
release, use the ISQL UNLOAD EXTERNAL command.
----------------------------------------------------------------------------
22630 MESSAGE WARNING - Table !.! has been created using
INTEGRITY CONSTRAINTS, which is not supported under
the target version of ALLBASE/SQL (DBWARN 22630).
This table will be dropped during the migration.
CAUSE A backward migration was PREVIEWED when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION If you need to transfer this data to the target
release, use the ISQL UNLOAD EXTERNAL command.
----------------------------------------------------------------------------
22640 MESSAGE WARNING - Table !.! has been created using
DEFAULT column values, which is not supported under
the target version of ALLBASE/SQL (DBWARN 22640).
This table will be dropped during the migration.
CAUSE A backward migration was PREVIEWED when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION If you need to transfer this data to the target
release, use the ISQL UNLOAD EXTERNAL command.
----------------------------------------------------------------------------
22650 MESSAGE WARNING - TEMPSPACE ! has been created using the
CREATE TEMPSPACE statement, which is not supported
under the target version of ALLBASE/SQL (DBWARN
22650). This TEMPSPACE will be dropped during the
migration.
CAUSE A backward migration was PREVIEWED when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION No action is necessary.
----------------------------------------------------------------------------
22670 MESSAGE WARNING - INDEX has been defined on sixteen (16)
columns. (DBWARN 22670). Index ! defined on table
!.! will be dropped during the migration.
CAUSE A backward migration was PREVIEWED when this
message was issued. In the target release, the
maximum number of columns on which an index may be
defined is fifteen (15). Functionality that is not
present in the target release has been detected.
ACTION After migration to the target release, recreate the
dropped index using fewer columns.
----------------------------------------------------------------------------
22690 MESSAGE WARNING - View !.! was not found, so it will not
be dropped during the migration (DBWARN 22690).
CAUSE A PREVIEW command was in progress when this message
was issued. SQLMigrate could not find a view that
needs to be dropped during the migration. The
DBEnvironment is probably being migrated a second
time (i.e. backward after a forward migration, or
forward after a backward migration) without
performing a START DBE NEWLOG after the first
migration.
ACTION No action is necessary.
----------------------------------------------------------------------------
22695 MESSAGE WARNING - View !.! was not found, so it was not
dropped (DBWARN 22695).
CAUSE A MIGRATE command was in progress when this message
was issued. SQLMigrate could not find a view that
needs to be dropped during the migration. The
DBEnvironment is probably being migrated a second
time (i.e. backward after a forward migration, or
forward after a backward migration) without
performing a START DBE NEWLOG after the first
migration.
ACTION No action is necessary.
----------------------------------------------------------------------------
22700 MESSAGE WARNING - View !.! is defined on a table or view
that will be dropped during the migration (DBWARN
22700). This view will also be dropped. The
SELECTSTRING from SYSTEM.VIEWDEF for this view is:
!
CAUSE A PREVIEW command was in progress when this message
was issued. The view is being dropped because a
structure that it is dependent upon is being
dropped.
ACTION You may wish to recreate the view after the
DBEnvironment has been migrated by typing the
command recorded in the SELECTSTRING.
----------------------------------------------------------------------------
22710 MESSAGE WARNING - View !.! is defined on a table or view
that is being dropped (DBWARN 22710). This view
is also being dropped. The SELECTSTRING from
SYSTEM.VIEWDEF for this view is: !
CAUSE A MIGRATE command was in progress when this message
was issued. The view is being dropped because a
structure that it is dependent upon is being
dropped.
ACTION You may wish to recreate the view after the
DBEnvironment has been migrated by typing the
command recorded in the SELECTSTRING.
----------------------------------------------------------------------------
22720 MESSAGE WARNING - Table !.! has been created using CHECK
CONSTRAINTS, which is not supported under the
target version of ALLBASE/SQL (DBWARN 22720).
This table will be dropped during the migration.
CAUSE A backward migration was PREVIEWED when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION No action is necessary. If you need to transfer
this data to the target release, use the ISQL
UNLOAD EXTERNAL command.
----------------------------------------------------------------------------
22730 MESSAGE WARNING - Table !.! has been created using CHECK
CONSTRAINTS, which is not supported under the
target version of ALLBASE/SQL (DBWARN 22730).
This table is being dropped.
CAUSE A backward migration was in progress when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION If you need to recover the table, the backup
version of the DBEnvironment must be restored. If
you need to transfer this data to the target
release, use the ISQL UNLOAD EXTERNAL command.
----------------------------------------------------------------------------
22740 MESSAGE WARNING - Table/view !.! is owned by user
HPODBSS, and is assumed to be part of the ObjectDB
product (DBWARN 22740). ObjectDB is not supported
under the target version of ALLBASE/SQL. This
table/view will be dropped during the migration.
CAUSE A backward migration was PREVIEWED when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION If the object is a table and you need to transfer
this data to the target release, use the ISQL
UNLOAD EXTERNAL command. If the object is a view,
then the SELECTSTRING from SYSTEM.VIEWDEF for the
view will be listed immediately after this message.
You may wish to recreate the view after the
DBEnvironment has been migrated by typing the
command recorded in the SELECTSTRING.
----------------------------------------------------------------------------
22750 MESSAGE WARNING - Table/view !.! is owned by user
HPODBSS, and is assumed to be part of the ObjectDB
product (DBWARN 22750). ObjectDB is not supported
under the target version of ALLBASE/SQL. This
table/view is being dropped.
CAUSE A backward migration was in progress when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION If the object is a table and you need to recover
the table, the backup version of the DBEnvironment
must be restored. If you need to transfer this
data to the target release, use the ISQL UNLOAD
EXTERNAL command. If the object is a view, then
the SELECTSTRING from SYSTEM.VIEWDEF for the view
will be listed immediately after this message. You
may wish to recreate the view after the
DBEnvironment has been migrated by typing the
command recorded in the SELECTSTRING.
----------------------------------------------------------------------------
22760 MESSAGE WARNING - Table/view !.! is owned by user
CATALOG, which will become a special user under the
target version of ALLBASE/SQL (DBWARN 22760). New
views owned by CATALOG will be created during the
START DBE command under the target version of
ALLBASE/SQL. To ensure that ALLBASE/SQL is able to
create all new views correctly, please take the
following steps using the target version of
ALLBASE/SQL: 1) perform a START DBE NEWLOG command
(to complete the migration of this DBEnvironment),
2) perform a DROP TABLE or DROP VIEW command to
drop this table/view, 3) perform a STOP DBE
command, and 4) perform a START DBE command, to
ensure that all new views owned by CATALOG are
created correctly.
CAUSE A forward migration was either PREVIEWED or in
progress when this message was issued. User data
which may cause unexpected problems within
ALLBASE/SQL has been detected.
ACTION Perform the steps listed in the message.
----------------------------------------------------------------------------
22780 MESSAGE WARNING - Table/view !.! is owned by user
HPODBSS, which will become a special user under the
target version of ALLBASE/SQL (DBWARN 22780). To
ensure that unexpected problems are not
encountered, please take the following steps using
the target version of ALLBASE/SQL: 1) perform a
START DBE NEWLOG command (to complete the migration
of this DBEnvironment), and 2) perform a DROP TABLE
or DROP VIEW command to drop this table/view.
CAUSE A forward migration was either PREVIEWED or in
progress when this message was issued. User data
which may cause unexpected problems within
ALLBASE/SQL has been detected.
ACTION Perform the steps listed in the message.
----------------------------------------------------------------------------
22900 MESSAGE WARNING - Procedure !.! has been detected in the
system catalog (DBWARN 22900). Procedures are not
supported under the target version of ALLBASE/SQL,
so this information will be dropped during the
migration.
CAUSE A backward migration was PREVIEWED when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION No action is necessary.
----------------------------------------------------------------------------
22910 MESSAGE WARNING - Procedure !.! has been detected in the
system catalog (DBWARN 22910). Procedures are not
supported under the target version of ALLBASE/SQL,
so this information is being dropped.
CAUSE A backward migration was in progress when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION No action is necessary.
----------------------------------------------------------------------------
22920 MESSAGE WARNING - Rule !.! has been detected in the
system catalog (DBWARN 22920). Rules are not
supported under the target version of ALLBASE/SQL,
so this information will be dropped during the
migration.
CAUSE A backward migration was PREVIEWED when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION No action is necessary.
----------------------------------------------------------------------------
22930 MESSAGE WARNING - Rule !.! has been detected in the
system catalog (DBWARN 22930). Rules are not
supported under the target version of ALLBASE/SQL,
so this information is being dropped.
CAUSE A backward migration was in progress when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION No action is necessary.
----------------------------------------------------------------------------
22940 MESSAGE WARNING - Module !.! is owned by user HPODBSS,
and is assumed to be part of the ObjectDB product
(DBWARN 22940). ObjectDB is not supported under
the target version of ALLBASE/SQL. This module
will be dropped during the migration.
CAUSE A backward migration was PREVIEWED when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION No action is necessary.
----------------------------------------------------------------------------
22950 MESSAGE WARNING - Module !.! is owned by user HPODBSS,
and is assumed to be part of the ObjectDB product
(DBWARN 22950). ObjectDB is not supported under
the target version of ALLBASE/SQL. This module is
being dropped.
CAUSE A backward migration was in progress when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION No action is necessary.
----------------------------------------------------------------------------
22960 MESSAGE WARNING - DBEFile ! in DBEFileSet ! is a
pseudo-mapped file, which is not supported under
the target version of ALLBASE/SQL (DBWARN 22960).
The MPE/iX filename for this DBEFile is !.
SQLMIGRATE will not perform a migration on the
DBEnvironment if any pseudo-mapped files exist when
the MIGRATE command is issued.
CAUSE A backward migration was PREVIEWED when this
message was issued. User data which takes
advantage of functionality that is not present in
the target release has been detected.
ACTION Use the SQLUtil MOVEFILE command to move this
DBEFile into a mapped file before attempting the
migration.
----------------------------------------------------------------------------