SAP Knowledge Base Article - Preview

2348911 - "(0 rows affected)" message may be shown when dump database command is complete. - SAP ASE

Symptom

A message "(0 rows affected)" may be shown like below when a dump database command finishes.

1> dump database testdb to "/tmp/testdb.dmp"
2> go

Backup Server: 4.172.1.4: The value of 'allocated pages threshold' has been set to 40%.
Backup Server session id is: 22. Use this value when executing the 'sp_volchanged' system stored procedure after
fulfilling any volume change request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'testdb162091027E ' section number 1 mounted on disk file '/tmp/testdb.dmp'
Backup Server: 4.188.1.1: Database testdb: 3322 kilobytes (1%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 17716 kilobytes (2%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 25506 kilobytes (4%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 26448 kilobytes (8%) DUMPED.

.....omitted.....

Backup Server: 4.188.1.1: Database testdb: 33588 kilobytes (94%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 33928 kilobytes (98%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 34098 kilobytes (100%) DUMPED.
Backup Server: 3.43.1.1: Dump phase number 1 completed.
Backup Server: 4.188.1.1: Database testdb: 62244 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 90804 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 119382 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 147330 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 176340 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 204214 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 232774 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 261352 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 268494 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 274136 kilobytes (100%) DUMPED.
Backup Server: 3.43.1.1: Dump phase number 2 completed.
Backup Server: 4.188.1.1: Database testdb: 276414 kilobytes (100%) DUMPED.
Backup Server: 3.43.1.1: Dump phase number 3 completed.
Backup Server: 4.188.1.1: Database testdb: 276418 kilobytes (100%) DUMPED.
Backup Server: 3.42.1.1: DUMP is complete (database testdb).
(0 rows affected)


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

dump database 0 rows affected nocount , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

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

Search for additional results

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