Problem retrieving data from db2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 63
- Joined: Mon Sep 12, 2011 2:11 am
Problem retrieving data from db2
this is the first time i use version 8.5 , my job flow is something like this :
DB2 Connector --> Sequential File
In DB2 Connector , after doing all the configuration , the test connection is ok and able to view the data also.
In Sequential File , the columns is also well defined.
The job is also able to compile without any error occurred but cannot run.
This is the job log from DS Director :
main_program: Fatal Error: An error occurred while getting the DB2 instance. Verify that a valid DB2 instance is specified in the Instance property. The method sqlegins returned reason code 0, SQLCODE -1,390.
Thank you.
DB2 Connector --> Sequential File
In DB2 Connector , after doing all the configuration , the test connection is ok and able to view the data also.
In Sequential File , the columns is also well defined.
The job is also able to compile without any error occurred but cannot run.
This is the job log from DS Director :
main_program: Fatal Error: An error occurred while getting the DB2 instance. Verify that a valid DB2 instance is specified in the Instance property. The method sqlegins returned reason code 0, SQLCODE -1,390.
Thank you.
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI
Hi ,
Could please conform which stage an which back end environment you are using
Stages like (DB2 API, DB2 Enterprise)
Back end like (unix,aix ,mainframe)
why because in main frame environment we tried with DB2 enterprise stage we too face the same problem an we find that in mainframe environment we can't able to use this DB2 Enterprise stage
Please correct me if i am wrong
Could please conform which stage an which back end environment you are using
Stages like (DB2 API, DB2 Enterprise)
Back end like (unix,aix ,mainframe)
why because in main frame environment we tried with DB2 enterprise stage we too face the same problem an we find that in mainframe environment we can't able to use this DB2 Enterprise stage
Please correct me if i am wrong
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 63
- Joined: Mon Sep 12, 2011 2:11 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: