Hi
I have started the job it is been running for quite some time.all the db stage showing me that record count but the job still is running.
is any of you getting this type message like
Requesting delayed metadata or Logging delayed metadata.
it is print for every stage looks like ..can anybody share the inf what does it really mean or doing.
Thanks
pK
Requesting delayed metadata or Logging delayed metadata.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Thu Jul 26, 2007 6:11 am
Does this thread apply to you?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
Anyone have anything more to add to this?
We are experiencing the same situation where a query in a SYBASE OCPX stage is hanging for hours at the "Logging delayed metadata" point. We have obtained the following results:
1. The query runs quickly when submitted via isql or DBArtisan.
2. The query runs quickly within DataStage when ran against a different Sybase instance.
3. The query hangs when ran from another DataStage server against the same database instance.
So it looks like we can't blame this on DataStage or Sybase alone. My guess is that some sort of communication hangup is occurring between the two, although no one can figure it out. Our DBA can see the query ran on the database, but that's as much visibility that she has. Our Datstage support group has monitored our jobs and can see that the query is being submitted, but then can only point to the database as the source of the problem.
Anyone know more about the communication protocol between DataStage and Sybase through the OCPX stage? Specifically, how do the two argee that a query is complete and an entire result set has been returned? Where could the process be hanging up? Any help will be greatly appreciated, as this has us all stumped...
We are experiencing the same situation where a query in a SYBASE OCPX stage is hanging for hours at the "Logging delayed metadata" point. We have obtained the following results:
1. The query runs quickly when submitted via isql or DBArtisan.
2. The query runs quickly within DataStage when ran against a different Sybase instance.
3. The query hangs when ran from another DataStage server against the same database instance.
So it looks like we can't blame this on DataStage or Sybase alone. My guess is that some sort of communication hangup is occurring between the two, although no one can figure it out. Our DBA can see the query ran on the database, but that's as much visibility that she has. Our Datstage support group has monitored our jobs and can see that the query is being submitted, but then can only point to the database as the source of the problem.
Anyone know more about the communication protocol between DataStage and Sybase through the OCPX stage? Specifically, how do the two argee that a query is complete and an entire result set has been returned? Where could the process be hanging up? Any help will be greatly appreciated, as this has us all stumped...
-
- Participant
- Posts: 35
- Joined: Wed Jun 15, 2005 9:27 am
Hi everyone,
This is also happening with our job (DS8.1): Select from DB2 -> Transformer -> Insert with Oracle Connector.
It runs perfectly in DEV,TST and QLT environments, but in Production environment it takes too much time while waiting for log entry "main_program: Requesting delayed metadata.".
We already tried setting DS_NO_PROCESS_METADATA=1 at project level but it did not work.
One of the tests we made was pointing the DataStage jobs to QLT Oracle database, the result was good, the job runned in a few minutes. So, for now I am directing my investigation to what Oracle sessions in PRD environment may tell.
Meanwhile, if anyone has more inputs on this matter please post.
Thank you!
This is also happening with our job (DS8.1): Select from DB2 -> Transformer -> Insert with Oracle Connector.
It runs perfectly in DEV,TST and QLT environments, but in Production environment it takes too much time while waiting for log entry "main_program: Requesting delayed metadata.".
We already tried setting DS_NO_PROCESS_METADATA=1 at project level but it did not work.
One of the tests we made was pointing the DataStage jobs to QLT Oracle database, the result was good, the job runned in a few minutes. So, for now I am directing my investigation to what Oracle sessions in PRD environment may tell.
Meanwhile, if anyone has more inputs on this matter please post.
Thank you!