Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Triggers
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. -
udb 5.2 Create from Backup not working for 9GB database
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... -
How can I migrate Oracle to IBM DB2
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... -
db2 linux odbc startup problem
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... -
Cross Tab and Decode in SQL
I think you may use the instruction CASE. This is the way I do it. bye -
