Skip to Content
0
May 11, 2016 at 01:19 PM

LOAD DATABASE WITH HEADERONLY output change

458 Views

Hello,

Somewhere between "Adaptive Server Enterprise/16.0/EBF 22383 SMP/P/x86_64/Enterprise Linux/asecepheus/3530/64-bit/FBO/Sun Feb 16 06:09:40 2014" and "Adaptive Server Enterprise/16.0 SP02 PL01/EBF 25184 SMP/P/x86_64/Enterprise Linux/ase160sp02pl00/2424/64-bit/FBO/Thu Sep 17 22:46:42 2015", the output of "LOAD DATABASE WITH HEADERONLY" changed significantly breaking some of our products parsing logic.

Just curious if there is a trace flag that would revert the output?

Also curious if there was ever discussion of recording backup information in a table similar to how other products do it so that it is easily queried?

Older HEADERONLY output:

1> load database pubs2 from '/home/sybase/backups2/pubs2.full.1' with headeronly

2> go

Backup Server session id is: 13. 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 'pubs216131076CA ' section number 1

mounted on disk file '/home/sybase/backups2/pubs2.full.1'

This is a database dump of database ID 13, name 'pubs2', from May 10 2016

8:26AM. ASE version: Adaptive Server Enterprise/16.0/EBF 22383

SMP/P/x86_64/Enterprise Linux/asecepheus/3530/64-bit/FBO/S. Backup Server

version: Backup Server/16.0/EBF 22383/P/Linux AMD Opteron/Enterprise

Linux/asecepheus/4465/64-bit/OPT/Sun Fe. Database page size is 4096.

Database contains 1792 pages; checkpoint RID=(Rid pageid = 0x529; row num =

0xd); next object ID=1312004674; sort order ID=50, status=0; charset ID=1.

Database encrypted: NO

Database Encryption Key: N/A

Database log version=7; database upgrade version=41; database

durability=UNDEFINED.

Full dump timestamp: 0x0000 0x00000000

Cumulative dump timestamp: 0x0000 0x00000000

Delta dump timestamp: 0x0000 0x00000000

segmap: 0x00000007 lstart=0 vstart=[vpgdevno=0 vpvpn=60420] lsize=1792

unrsvd=559

The database contains 1792 logical pages (7 MB) and 1792 physical pages (7 MB).

dbdevinfo: devtype=0 vdevno=0 devname=master

physname=/opt/sybase/devices/data1/S1_master.dat devsize=102400 dbdevsize=1792

vstart=0 devstat=3 devstat2=0

This is the SYSDATABASES row of database ID 13, name 'pubs2' from the dump

header. Status:0x0009. Crdate:May 10 2016 8:25AM. Dumptrdate:May 10 2016

8:25AM. Status2:0xffff8000. Audflags:0x0000. Deftabaud:0. Defvwaud:0.

Defpraud:0. Def_remote_type:0. Status3:0x20000. Status4:0x4000. Durablility:1.

Lobcomp_lvl:0. Inrowlen:0. Dcompdefault:1. Status5:0x0000.

This is the SYSATTRIBUTES row for the database 'pubs2' from the dump header.

Flmode:0x0000.

Features found in the database or transaction dump header:

ID = 4 : 15.7.0.000 : Database has system catalog changes made in 15.7 GA

ID = 7 : 15.7.0.020 : Database has system catalog changes made in 15.7

ESD#02

ID = 11 : 15.7.0.100 : Database has the Sysdams catalog

ASE 16 SP02 PL01 "LOAD DATABASE ... WITH HEADERONLY" output looks like:

Backup Server session id is: 29. 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 'pubs2161310649A ' section number 1 mounted on disk file '/home/sybase/backups/pubs2.full.1'

General:

This is a full database dump

Name: pubs2

Id: 4

Dump date: May 10 2016 7:09AM

Database page size: 4096.

Number of pages: 1792

Checkpoint RID: (1329, 33)

Next object id: 1312004674

Sort order id: 50

Status: 0

Charset id: 1

Database durability: UNDEFINED

Compression level: N/A

Database encrypted: NO

Database Encryption Key: N/A

Versions:

Adaptive Server version: Adaptive Server Enterprise/16.0 SP02 PL01/EBF 25184 SMP/P/x86_64/Enterprise Linux/ase160sp02pl00/242

Backup Server version: Backup Server/16.0 SP02 PL01/EBF 25184/P/Linux AMD Opteron/Enterprise Linux/ase160sp02pl00/4902/64-

Database log version: 7

Database upgrade version: 41

Dump timestamps:

Full: 0x0000 00000000

Cumulative: 0x0000 00000000

Delta: 0x0000 00000000

Sysusages:

segmap: 0x00000007 lstart=0 vstart=[0, 22532] lsize=1792 unrsvd=494

Number of logical pages: 1792 (7 MB)

Number of physical pages: 1792 (7 MB)

Sysdevices:

devtype=0, vdevno=0, devname=master,

physname=/opt/sybase16sp2/data/master.dat,

devsize=40960, dbdevsize=1792, vstart=0,

devstat=3, devstat2=0

Sysdatabases:

status=0x0008, crdate=May 10 2016 7:01AM,

dumptrdate=May 10 2016 7:01AM, status2=0xffff8000,

audflags=0x0000, deftabaud=0, defvwaud=0, defpraud=0,

def_remote_type=0, status3=0x20000, status4=0x4000,

durablility=1, lobcomp_lvl=0, inrowlen=0,

dcompdefault=1 status5=0x0000

Sysattributes:

flmode: 0x0000

Features found in the database or transaction dump header:

ID = 4 : 15.7.0.000 : Database has system catalog changes made in 15.7 GA

ID = 7 : 15.7.0.020 : Database has system catalog changes made in 15.7 ESD#02

ID = 11 : 15.7.0.100 : Database has the Sysdams catalog

Thanks,

Neal