SAP Knowledge Base Article - Preview

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

Symptom

  • 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


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.