|
I realized that there is another way to create this database on DB2
on i if I can create the empty table structure on “Venus” and then I
can use Rollbase to re-initialize the seed data. Then we can get the
database ready on DB2 on i. so I managed to extract all the table DDL
from my DB2 on LUW version instance, and made some changes to make it
DB2 on i compatible and try to create all objects in the “Venus”
server. I created a schema “RB_DBO” and created all tables
successfully, but when I try to create Primary Key constraints on
these table, I got a SQL exception “ErrorCode: -5051”, some thing
like :
Error: [SQL5051] Qualifier LEON not same as RB_DBO.
SQLState: 42875
ErrorCode: -5051
Error occurred in:
ALTER TABLE "RB_DBO"."RB_ACTION" ADD CONSTRAINT "PK_RB_ACTION" PRIMARY KEY ("ACTION_ID")
Error: [SQL5051] Qualifier LEON not same as RB_DBO.
SQLState: 42875
ErrorCode: -5051
I did some research on this error, and I believe the reason is that
the “leon” account didn’t have “Alter table” privilege on tables in
schema “RB_DBO”.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.