How to view a tables DDL

[ddiamond]

I'm trying to display a tables DDL. I went into the control center, right clicked on the table, and clicked on the command "Generate DDL". This generates the following error message:

SQL4414N  The DB2 Administration Server is not active.

Explanation: 

The request cannot be processed unless the DB2 Administration 
Server is active.  

User Response: 

Start the DB2 Administration Server by issuing the command 
DB2ADMIN START, and reissue the request.

I tried the command DB2ADMIN START, but db2 tells me it does not recognize that command. Does anyone have any suggestions? Can anyone tell what the DB2 Administration server is?

 

[macehill]

Presumably you're trying to look at the ddl for a table on a remote database. Each server i.e. physical machine which has DB2 on it has a DB2 Administration Server. This allows remote Administration Clients to discover what instances and databases are on the server and to interact with them.
I imagine the problem that you're experiencing is that you're trying to issue "db2admin start" on the client rather than on the server.