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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

db2look does not export stored procedures

Status
Not open for further replies.
NewBlue

NewBlue

Programmer
Dec 2, 2003
11
0
0
CA
I am using db2move and db2look to clone a database. My problem is that I cannot get db2look to generate stored procedure ddl.
Everything I read says this tool should generate the ddl for stored procedures. I have tried all options -e -a you name it. Is there some access and/or priveledge I have to set to have access to the stored procedure source ?
 
Status
Not open for further replies.

Similar threads

usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
44
usr1234
usr1234
Kuldeepg
  • Locked
  • Question
Timestamp_format is not libl function
Replies
1
Views
76
mikrom
mikrom
ColeFern
  • Locked
  • Question
SQL1224N A database agent could not be started to service a request, or was terminated as a result
Replies
0
Views
59
ColeFern
ColeFern
DMo42
  • Locked
  • Question
DB2 11.1 SQL1022C There is not enough memory available to process the command
Replies
0
Views
61
DMo42
DMo42
evr72
  • Locked
  • Question
Nothing happens creating a new ODBC DSN for iSeries
Replies
3
Views
55
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top