Hello !!
Alright, I'm trying to import table definitions using orchdbutil (Import - Orchestrate Schema Definitions ).
I have entered the following details in the import Orchestrate Schema dialog box:
Table name
For Owner is grayed out
DBMS type
Database name
Database server:
Username
password
Charset/Map
Use own DB options is checked
When I hit 'Next', it says Cannot get schema definition for requested database table: "Table_name" (DB2)
When I view output from server command, I get the following message which seems to be the most 'useful' of all:
DB2Driver Embedded SQL message: SQL30082N Security processing failed with reason "3" ("PASSWORD MISSING").
Now, I know I have provided the password in the password field. I also tried unchecking the 'Use own DB options' to manually type in the password and it still gives me the same error.
Has anybody come across such an error message before?
Thanks,
Hiral
Unable to use ORCHDBUTIL
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 45
- Joined: Fri Nov 07, 2008 12:22 pm
Unable to use ORCHDBUTIL
Thanks,
Hiral Chauhan
Hiral Chauhan
-
- Premium Member
- Posts: 45
- Joined: Fri Nov 07, 2008 12:22 pm
For some reason, since this morning, I'm not able to import DB2 table definition using ODBC for a particular table. I was advised to used Plug-in meta data or Orchdbutil as a work around.
Plug-in Metadata works just fine. But Orchdbutil does not work.
I was hoping that there would be a way to find out why this utility won't work.
Plug-in Metadata works just fine. But Orchdbutil does not work.
I was hoping that there would be a way to find out why this utility won't work.
Thanks,
Hiral Chauhan
Hiral Chauhan
-
- Premium Member
- Posts: 175
- Joined: Tue Oct 14, 2008 1:48 pm
[quote="hiral.chauhan"]For some reason, since this morning, I'm not able to import DB2 table definition using ODBC for a particular table. I was advised to used Plug-in meta data or Orchdbutil as a work around.
Can you tell us how did you use orchdsutil. I have table by name employee in dev server and user name as dsadm and passowrd as dsadm. Can you tell me the syntax.
Thanks,
Can you tell us how did you use orchdsutil. I have table by name employee in dev server and user name as dsadm and passowrd as dsadm. Can you tell me the syntax.
Thanks,
Rajesh Kumar
-
- Premium Member
- Posts: 45
- Joined: Fri Nov 07, 2008 12:22 pm
I'm not sure what you mean by syntax. In Datastage, I use Import - Table Definitions - Orchestrate Schema Definitions and fill in the dialog box with the appropriate values for:
-Table name
-(For Owner is grayed out)
-DBMS type
-Database name
-Database server
-Username
-password
-Charset/Map
-Use own DB options is checked
-Table name
-(For Owner is grayed out)
-DBMS type
-Database name
-Database server
-Username
-password
-Charset/Map
-Use own DB options is checked
Thanks,
Hiral Chauhan
Hiral Chauhan
-
- Premium Member
- Posts: 45
- Joined: Fri Nov 07, 2008 12:22 pm