CSTAR database for advanced test systems

The CSTAR (cards status tracking recording) database tracks inventory redesign/failure history of the field replaceable units (cards and components) that make up the VLSI device advanced test systems (ATS) that have been designed and manufactured at IBM, East Fishkill. CSTAR obsoletes the process of logging hardware failures in a notebook where inventory and failure-to-repair actions can not be easily identified. CSTAR provides an automatic serial number generator facility for new card tracking, status histories of all cards, SQL reports for analyzing failure histories for the most frequently used repair process, engineering change summaries per card, and a comprehensive user´s guide (on-line and hard copy.) CSTAR runs in a distributed environment with LANs providing the link to a centralized database enabling all information to be immediately available to all authorized users in the laboratory and manufacturing test areas. Since repair attempts now have a consistent approach, second and third shift problem take over is accelerated and simplified, and hardware maintenance programs are forecasted, there is enhanced equipment reliability by reduced unplanned maintenance and quicker turn around time