Monthly Archives: May 2017

SQL2547N while restoring database on DB2 10.5

While restoring database from DB2 9.7 to DB2 10.5 I encountered the following error:

PROBLEM

SQL2547N
The database was not restored because the backup image is from a previous release and requires rollforward recovery.

TAKEN ACTION:

I ran the DB2 check backup command db2ckbkp -h <backup_file_name>.001

And resulted with:
[1] Buffers processed: #################

Image Verification Complete – successful.

SOLUTION:

To resolve the problem a new OFFLINE backup is needed, power down your db instance and take a new backup.

Setup Proxy in SUSE/VCSA

To setup proxy manually in VCSA 5.5 login as root and look into the following file:

/etc/sysconfig/proxy

PROXY_ENABLED=”yes”

HTTP_PROXY=”http://<IP address or FQDN>:<port_number>”

HTTPS_PROXY=”http://<IP address or FQDN>:<port_number>”

FTP_PROXY=”http://<IP address or FQDN>:<port_number>”

NO_PROXY=”localhost, 127.0.0.1″

 

If you need to authenticate via proxy

Create a file in your home directory,

/root/.curlrc with permissions 644

and contain the following:

# Proxy credentials

proxy-user = “<username>:<password>”

source the file to apply the changes

source /root/.curlrc