BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi all,

i have created job using update/insert loader. My source will be from oracle.

After adding DB commit(1000), DI Job status is always in running mode and log is not
generated as the job is not getting ended.

(using smc - data library manager - sas libraries -Mylibrary(right click -options -advanced options - output - 1000)

pls guide me asap
2 REPLIES 2
LinusH
Tourmaline | Level 20
Maybe it's best to get help from SAS tech support for these kind of problems.
Meanwhile, you might try to get some help with monitoring the oracle load process, to get a clue about what's going on.
If you have lots of data and performance issues, I suggest that you use bulk-load for your inserts.
/Linus
Data never sleeps
Patrick
Opal | Level 21
Where did you add DB commit?

I'm regularly writing DI jobs updating/inserting into Oracle tables and I never set a explicit commit.

I run already into issues when I executed the code via a session (i.e. in the DIS code window). It always worked when I executed the same code in batch (I had so far never the time to investigate why I observed these differences in behaviour between executing code in a session or in batch but it might well be caused by a missing commit).

Looking at the code passed to the DBMS I always assumed that the commit is given implicit after the execute block ends.

If you're having issues then may be autocommit might help you: http://support.sas.com/onlinedoc/913/getDoc/en/acreldb.hlp/a001371521.htm

Or you could use dbcommit=0 - but read the doku as there are some backdraws with where clauses.


HTH
Patrick

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1039 views
  • 0 likes
  • 3 in conversation