2054254 - Execution of DBCC GETTRUNC or SETTRUNC returns large, negative values for the ltm_truncpage field - SAP ASE

• DBCC GETTRUNC returns a large, negative value for the truncation page:

1> dbcc gettrunc
2> go
ltm_truncpage ltm_trunc_state db_rep_stat gen_id      dbid
         dbname                         lti_version
------------- --------------- ----------- ----------- ------
         ------------------------------ -----------
    -536858378               1           1           0      4
         test             

• DBCC SETTRUNC does the same thing:

1> dbcc settrunc(ltm, valid)
2> go
ltm_truncpage ltm_trunc_state db_rep_stat gen_id      dbid
         dbname                         lti_version
------------- --------------- ----------- ----------- ------
         ------------------------------ -----------
    -536858375               1           1           0      4
         test          

•  Problem occurs only for databases with more than 2,147,483,648 logical pages

• SAP Adaptive Server Enterprise (ASE) 15.7 
• SAP Adaptive Server Enterprise (ASE) 16.0 GA

sybase, int, , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed