CA DB2 tools for z/OS Post Install Create Required DB2 Objects job ssid0001 gets B37-04
search cancel

CA DB2 tools for z/OS Post Install Create Required DB2 Objects job ssid0001 gets B37-04

book

Article ID: 280466

calendar_today

Updated On:

Products

DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

Job ssid0001 step EXECRBP2 fails on the copy part of the reorg of a tablespace due to not enough sort work. 
It fails on file 'userid.PTDB.PTTSRTB7.ssid.SCPY'. This file is allocated too small and gives  B37-04.

Environment

z/os Post Install jobs being run

Cause

out of date runstats on the object

Resolution

Submit a RUNSTATS command against the failing object and rerun the job