Tech Tip from Karina Pulinx, Principal Support Engineer for February 6, 2017. With CA Datacom/DB 15.0 RO93515, MUF console command STATUS LOG now displays column %FULL indicating how full the LXX is. This was already available in version 15.1 via RO93585.
CA Tech Tip from Karina Pulinx, Principal Support Engineer, for May 31,2016 . After upgrade from CA Datacom 12.0 to 14.0 SQL statement SELECT ENCRYPTION TYPE ,ENCRYPTION METHOD FROM SYSADM.AGGREGATE fails with SQLCODE -9 ‘ ILLEGAL COLUMN NAME ’ . These columns ,ENCRYPTION...
Tech Tip from Karina Pulinx , Principal Support Engineer , for February 9 ,2016 . With CA Datacom SQL version 14.0 enhancement PTF RO50843 and version 15.0 we pull the stored row count from the CXX rather than reading the entire table to count the rows in a table when running SELECT...
Tech Tip from Karina Pulinx , Principal Support Engineer , for October 15 ,2015 . After IPL of the LPAR where the 14.0 CA Datacom Multi-User (MUF) is running some batch programs are getting a S0C1 abend in DBINRPR +4B48 . Those batch programs are accessing tables or files under...
A database containing SQL tables has been created in test status in CA Datadictionary Version 14.0 . You run a VERIFY DATABASE and the verification is successful while you were expecting to get message DDWTBL0051 TABLE IN TEST STATUS NOT SQL ACCESSIBLE ...