BookmarkSubscribeRSS Feed
thomash123
Calcite | Level 5

Hi all,

strange issue here and I have no idea what's going on. Any hint would be highly appreciated.

A SAS job that runs fine during the night (hundreds of times already) runs once a month also during the day. This one time it loads 120.000 rows into the DB/2 instance, while during the night there are about 60.000 rows to process.

So when it comes to the daily run the job connects to DB/2 and...does nothing. It does neither loa nor update nor does the job itself crash with an error. It just idles on the DB without throwing any error on SAS or DB/2 side.

Has anyone experienced such an issue before? Please note, that this job connects to the very same DB and table in the night and runs fine. If the row number would be problem I would assume that other jobs, that do similar stuff with similar row number also crashed, but they run fine.

Thanks a lot for any idea,

Thomas

2 REPLIES 2
advoss
Quartz | Level 8

Has your DB2 administrator checked to see if there are any locks on the row, table, tablespace, etc?  That's the great thing about locks...SAS will just sit there and patiently wait for the lock to go away.  If this is a transactional database, it may be unused during the night, but nailed down during the day due to user activity.

Just a thought.  Good luck.

Al

thomash123
Calcite | Level 5

Sure, sure - of course there's nothing wrong with the DB Smiley Wink

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!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 848 views
  • 0 likes
  • 2 in conversation