The statspack scripts are notorious for having a WHENEVER SQLERR EXIT type clause in them which misbehaves. It probably tried to drop a table which wasn't there, saw it was an error, and exited without finishing the script. I would suggest you look at the spcreate script, understand what it is doing, and tie that back to the error you received.