Problem when extracting the structure of DB2 (Back up Structure)
1
vote
1
answer
72
views
I want to extract the structure of a 9.7 DB2 database to use to clone it but some of the authorization statements are missing afterwards:
I tried something like this:
db2look -d dbName -a -x -o db2look.sql
what I noticed, is that the *Authorization Statements on User Defined Functions* and *Stored Procedures* are missing.
I expected to see something like this: https://www-01.ibm.com/support/docview.wss?uid=swg1IC65658
EDIT: A try indicated, that this command correctly extracted the
GRANT
statements on the productive system.
Asked by Entomo
(111 rep)
Mar 30, 2016, 01:16 PM
Last activity: Mar 30, 2016, 03:23 PM
Last activity: Mar 30, 2016, 03:23 PM