Very basically, I have a BTEQ file that is 61,580 bytes. After running in circles for a short while, I have found that any BTEQ up to and including 61,440 bytes runs no problem, whilst anything over that just hangs indefinitely. Of course a simple fix is to reduce the file size ever so slightly, but that is not an option.
I've searched online and thought that the issue might be related to MaxParseTreeSeg in the dbscontrol, however I have increased this from 4000 up to 8000 and it hasn't solved the issue.
Any help regarding this fault is highly appreciated.
Thanks in advance.
After having come across the above issue again (this time with a file much larger than the 61k limit we seem to have) I've discovered that the BTEQ appears to run correctly when run from the command line manually. If the BTEQ is however run with the exact same command line command, but from a shell script (ksh), it appears to hang indefinitely.
I will still be looking for a solution to this odd issue and should I find it I will update this post with the answer.