Hello,
I would suggest a possible way to do that is to use federated databases. This feature of DB2 UDB allows to create nicknames that refer to objects in remote databases.
So the trigger can insert, update, delete in tables that are in other databases.
I hope it will be helpful.
Hello,
9GB is not so big. Maybe you might want to change some parameters of the instance that would allow DB2 to handle the restore:
db2 update dbm using restbufsz 4096: it will allocate 16Mo for the restore buffers instead of the usual 4Mo.
Moreover rather than using the graphical interface...
Your migration will be easier if you try the following steps:
- export your data of your tables to flat files;
- pay attention to date format: convert these dates into char format that db2 understands: it will be easier to do that if you use views to perform this conversion when exporting the...
Hello,
I think that the suggestion of Alphonsus is a good one. Moreover, make sure that your database manager is configured to accept TCPIP connections. (See get dbm cfg commands)
You can issue 'catalog tcpip node' commands and 'catalog database' commands in order to make sure that the access...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.