How To Rename Your Local Database

January 5, 2011 Hey, Ted

When I start up an interactive SQL session I see “Current connection is to relational database Sxxxxxxx.” Sxxxxxxx is our serial number. Is there a way to change the relational database name to something a little more meaningful?

–David

Use the Work with Relational Database Directory Entry (WRKRDBDIRE) command. The entry you need to change is for remote location *LOCAL. For more information about WRKRDBDIRE, see Using the WRKRDBDIRE command at IBM‘s Info Center.

–Ted

That solved the problem. It was little scary because I couldn’t change the name, but had to delete the existing one and recreate it. The second level text on the warning message let me know what to do, though.

–David

                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot

Tags:

YOUR ORGANIZATION NEEDS TO BE THINKING DIFFERENTLY ABOUT YOUR
BACKUP & DISASTER RECOVERY STRATEGY

Heightened Concerns of the Industry

Inefficient manual backup processes
Effectively storing data offsite
Developing and testing a concrete disaster recovery plan
Efficient access to data in disaster scenario for necessary users
Risk of cyber security attack
Declining IT staff and resources

The true cause of the above concerns is the “new normal” that is the COVID-19 pandemic and an organization’s status quo:

80% of IBM i users currently backup to tape and 40% of companies
have no DR plan at all.

DURING THIS UNPRESENTEDED TIME, DON’T WAIT FOR YOUR BUSINESS
TO SUFFER A DISASTER TO TAKE ACTION.

The new way to ensure cost-effective safety

Automated cloud backup
Two remote sites – redundant storage, power, internet pipe, firewalls, etc.
Data encryption at all times – in-flight and at-rest
Fully managed remote hardware DR, including remote VPN access for necessary users
Regularly simulated phishing tests and cyber security training

Potential “landmines” in solutions to avoid

Single point of storage – no redundancy
Misleading data analysis, compression/de-dup ratios, sizing of necessary computer resources for backup and DR
Large scale cloud storage with difficult recovery
Inability to meet RTO/RPO

Don’t get caught like the many organizations we’ve seen with inefficient
exposed backup data and no DR plan!

WHAT VAULT400 HAS TO OFFER

Backup

Native software agent schedules backups to the UCG cloud based on your retention scheme
Client data is backed up to two data centers in US or two data centers in Canada
AES bit 256 encryption in-flight and at-rest – 0nly client has the encryption key
Detailed data analysis to ensure proper sizing

Disaster Recovery as a Service

UCG provides “hands-off” DR – fully managed recovery
60 days remote VPN access available to unlimited users in event of disaster
Documented reports to ensure defined SLAs are met

VAULT400 for IBM BRMS Users

Revolutionary BRMS Backup
Custom configurations to meet your specific needs
Local and Remote Save Sets
IPL and Option 21 Full System Saves
Secure replication encryption; local archives and tape encryption support
Compression & Deduplication reduction up to 100:1
Full 24 to 48 hour DRaaS
Run remotely for up to 60 days
Supports All Platforms and Databases

Serving the US, Canada, & Latin America

Visit VAULT400.com/proposal to receive a FREE analysis and proposal

VAULT400 Cloud Backup & DRaaS is an IBM Server Proven Solution.

800.211.8798 | info@ucgtechnologies.com| ucgtechnologies.com/cloud

To the First Responders serving on the front-lines during the COVID-19 pandemic,
we extend our heartfelt gratitude.

Oracle’s Withdrawal of JDE ‘Blue Stack’ Raises Questions In the Best Interests of IBM i

Leave a Reply Cancel reply

THIS ISSUE SPONSORED BY:
SEQUEL Software WorksRight Software Bug Busters Software Engineering