Prev: COUNT(*) Not accurate?
Next: copy/move a table between two databases
From: Ultrak The DBA on 7 Apr 2010 09:50
for DB2 V9.5.0.4 is there a switch for db2look that will have it
create the db2 trusted context commands? I have noticed that the old
tried and true

db2look -d db1343 -z sdb1343 -e -l -f -c -x -o db1343.look

does not contain this data.

or is there another method for getting this data.

ie

CREATE TRUSTED CONTEXT trusted_cxt_16 BASED UPON CONNECTION USING
SYSTEM AUTHID bbartee default role EP_DATA_primary enable
ATTRIBUTES ( ADDRESS '192.168.0.1' ) ;
From: Serge Rielau on 8 Apr 2010 08:25
On 4/7/2010 9:50 AM, Ultrak The DBA wrote:
> for DB2 V9.5.0.4 is there a switch for db2look that will have it
> create the db2 trusted context commands? I have noticed that the old
> tried and true
>
> db2look -d db1343 -z sdb1343 -e -l -f -c -x -o db1343.look
>
> does not contain this data.
>
> or is there another method for getting this data.
>
> ie
>
> CREATE TRUSTED CONTEXT trusted_cxt_16 BASED UPON CONNECTION USING
> SYSTEM AUTHID bbartee default role EP_DATA_primary enable
> ATTRIBUTES ( ADDRESS '192.168.0.1' ) ;
I wonder whether the schema option and -e collide.
Remove the schema and see what happens.

Cheers
Serge


--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

 | 
Pages: 1
Prev: COUNT(*) Not accurate?
Next: copy/move a table between two databases