topic Can help us know why the two LONGJOBs did not finish when SAS appeared to be done running the code in the job? in SAS Programming https://communities.sas.com/t5/SAS-Programming/Can-help-us-know-why-the-two-LONGJOBs-did-not-finish-when-SAS/m-p/40908#M8387 <HTML><HEAD></HEAD><BODY><P> Are you running these jobs in batch?</P><P>What can you see in the log file?</P><P>If yo have trouble to see in what step you jobs is halting, try use the -logparm "write=immediate" system option, and potentially -altlog.</P><P>Since you are querying DB2, there might be a log there to whether your queries have been committed or not.</P><P></P><P>/Linus</P></BODY></HTML> Thu, 03 Nov 2011 12:50:52 GMT LinusH 2011-11-03T12:50:52Z Can help us know why the two LONGJOBs did not finish when SAS appeared to be done running the code in the job? https://communities.sas.com/t5/SAS-Programming/Can-help-us-know-why-the-two-LONGJOBs-did-not-finish-when-SAS/m-p/40907#M8386 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; color: black; font-family: 'Helv','sans-serif';">Two SAS jobs we submitted recently ran correctly at first, but didn't end normally.&nbsp; The jobs kept using cpu resources but were not doing any additional useful processing.&nbsp; The firs one abended when the cpu time limit was hit; we canceled the second one.&nbsp; The jobs have only two simple steps, a query to a development DB2 table and a sort of the result set.&nbsp; </SPAN></P></BODY></HTML> Thu, 03 Nov 2011 10:50:35 GMT https://communities.sas.com/t5/SAS-Programming/Can-help-us-know-why-the-two-LONGJOBs-did-not-finish-when-SAS/m-p/40907#M8386 Cherry 2011-11-03T10:50:35Z Can help us know why the two LONGJOBs did not finish when SAS appeared to be done running the code in the job? https://communities.sas.com/t5/SAS-Programming/Can-help-us-know-why-the-two-LONGJOBs-did-not-finish-when-SAS/m-p/40908#M8387 <HTML><HEAD></HEAD><BODY><P> Are you running these jobs in batch?</P><P>What can you see in the log file?</P><P>If yo have trouble to see in what step you jobs is halting, try use the -logparm "write=immediate" system option, and potentially -altlog.</P><P>Since you are querying DB2, there might be a log there to whether your queries have been committed or not.</P><P></P><P>/Linus</P></BODY></HTML> Thu, 03 Nov 2011 12:50:52 GMT https://communities.sas.com/t5/SAS-Programming/Can-help-us-know-why-the-two-LONGJOBs-did-not-finish-when-SAS/m-p/40908#M8387 LinusH 2011-11-03T12:50:52Z