SAP Knowledge Base Article - Preview

3517045 - Update index statistics slow down the database backup - SAP ASE for BS / BW

Symptom

  • DB Backup is taking long time
  • dbcc stacktrace of the spid of "dump databse"

Start dbcc stacktrace...
pc: 0x0000000002254f1b upsleepgeneric+0x5cb()
pc: 0x0000000000c9bed7 dfl_dmp_sleep+0x3d()
[Handler pc: 0x0x0000000000beabd8 dpdb_handle installed by the following function:-]
pc: 0x0000000000be7594 dpdb_main+0x10e4()
pc: 0x000000000206c990 s_execute+0xdcb0()
[Handler pc: 0x0x00000000020c7590 hdl_stack installed by the followingfunction:-]
[Handler pc: 0x0x000000000208b480 s_handle installed by the following function:-]
pc: 0x000000000208fc93 sequencer+0xd13()
pc: 0x000000000184252a tdsrecv_language+0x1ea()
[Handler pc: 0x0x00000000021e6020 ut_handle installed by the followingfunction:-]
pc: 0x0000000001859119 conn_hdlr+0xf19()
dbcc stacktrace finished.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

  • "update index statistics on table ** " maintained by ATM is running for a long time.
  • The following error in ASE errorlog
    Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment. 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite (BS) and Business Warehouse (BW)
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite (BS) and Business Warehouse (BW)
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

Keywords

KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

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.