Practical limit on number of nicknames?
From
Troels Arvin@21:1/5 to
All on Sun Feb 5 15:20:01 2017
For a database migration project I'm considering using DB2 federation:
From-database: F
To-database: T
Both F and T are DB2 on x86_64 Linux running DB2 v. 10.5FP8 or later.
F contains 100000+ tables which need to be moved from F to T, but it will
take a long while before F can be dropped. In the mean time, users should
not have to worry about where to find a given table.
I assume that with federation, I do the following for all the tables
which are to be moved:
1. Copy the table from F to T; in T: add SELECT grants to the relevant
federation user.
2. Drop the table in F.
3. Place a nickname in F, pointing to the corresponding table in T.
4. In F: Add relevant GRANTs on the nickname, matching those which
were present on the table.
Is there something I should worry about, given the large number of
nickname involved? I assume that DB2 has no theoretical problem handling
so many nicknames, but maybe someone has experience from the real world
which would be useful for me to know before committing to the idea?
--
Regards,
Troels Arvin
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)