Transcript Powerpoint - GlobalWare Big League Users Group

Suggestions for keeping your GlobalWare
Database Healthy.
April Sigmon
Sr. Technical Analyst
Application Support Team - Point of Sale
September 2010
Did you know….
2
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
September 23rd (today) is Hobbit day!!
Hobbits know how to party (like some of you), they
would dance, had fireworks and lots of food.
Celebrate today with a party like Bilbo's and don't
wear shoes in honor of the hobbits.
Hobbits don't wear shoes very often.
3
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
My role with the GlobalWare Product
4
•
Performing complex recoveries
•
Database corruptions
•
Purges
•
Assisting with your difficult installations.
•
MIR related issues, various errors, backup
•
Registry and new Operating Systems issues
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Let’s talk about the following…
5
•
Purging and why it is important
•
Recoveries
•
Keep current on the GlobalWare releases
•
Backing up your data
•
Silly tips
•
Open discussion / questions
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Purging
Why Purge?
You should purge because most of you have been building your
database for 11 years! It is time to begin off-loading some of that
data.
6
•
Increase the performance of your database queries (after your
recovery).
•
Decrease the size of your database (after your recovery).
•
Your purges should be done on a fast machine. The more RAM
you have the better off you are.
•
Look forward to command line purge in 5.10
•
Consider purging some data before your upgrade to 5.10
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Purge tips
Before you purge, be sure you have copies of all reports you need
that use this data (printed on paper or to file).
•Backup your database
• Start with small date ranges
•If you have never purged, start with Invoice only
Remember Shift F-7
7
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Main Causes of Database Corruptions
• Defects in the server such as hard disk corruption, memory or
cache faults
• Running out of space on the primary hard drive
• Power failures
• Forcefully stopping a Purge
• Viruses on the Database server
• Not keeping all your GlobalWare machines on the same version
8
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Recoveries
Why plan for a recovery?
•
To Keep your Database Healthy
•
The recovery will find errors within your DB and either notify you of the problem or
in some cases fix it.
Planning for an recovery.
9
•
Choose a date to run a recovery
•
Plan a time after hours or COB on a Friday and give yourself plenty of time to run
the recovery process.
•
Plan for this event – such as identifying whether you need Travelport assistance
before, during, or after your recovery.
•
Check for free drive space on your recovery machine. You need enough free
space that equals three times the size of your Database. For example, if your
database size = 2GB, you need at least 6GB of free space on the recovery drive
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Recoveries
• How fast your recovery runs depends on the machine’s hardware.
The better the machine, the quicker it will run. (The more RAM
you have, the faster it processes.)
• Turn off anti-virus before you run the recovery.
• Run DeleteDuplicateInvoices prior to the recovery.
Hint! Run a Defrag on the GlobalWare server after a recovery.
–Windows 7 Defrag is not great.. It is suggested to download a
freeware version.
10
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Maintaining your current hardware
• Clean up the hard drive (Use Disk Clean up).
• Scan for viruses and update virus definitions monthly.
• Check that you have a PS (uninterrupted power supply) on the
Database Server
• Increase the RAM in your current machine
• Develop a plan to replace the old server and invest in a new server
11
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
A Good Health Check
Run a validation:
A good health check to run periodically throughout the year is a database validation. A
validation of the database can insure that the database is not corrupt.
•
A validation will scan every record in every table.
•
Run the DBVAL on a non-production machine to avoid impacting your production
environment.
Check your backup:
Actually restoring the backup onto a non-production machine and verifying the data is
a great health check. Perhaps run your validation on this backup to ‘kill two birds with
one stone.’ Thus you can ensure that when you need to restore, you have a good
backup.
12
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Backup! Backup! Backup!
• When using the GwSrvBkp.exe on the backup server, it is
suggested that you install GlobalWare as a Single user on the
server. (We have found that when GW installed as a Workstation Client
on the server, the GwSrvBkp (and a few other utilities) will not work like
they should.)
• Other suggestions to backing up your GlobalWare server is to set
up a batch file with these commands:
dbbackup -c "eng=gwsrv;dbn=gwsrv;uid=global;pwd=ware" -d -t -y -o D:\GWbkup\gwbkp.log D:\GWbkup\gw
-d creates a backup of the main database file only
-t creates a backup of the transaction log only
-y creates directory or replace files without confirmation
-o Log output messages to file (this parameter has to be the last one and is followed
up by your path)
13
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Windows 7 & GlobalWare
To add the SQL10 driver manually, use these steps
Open hkey_local_machine\software\odbc\
Right-click obdcinst.ini, select New, Key.
Name it “SQL Anywhere 10”
Right-click “SQL Anywhere 10”, select New,
String Value. Name it “Driver”. Press Enter to
edit the string. Enter
“c:\gblware\sqlany\dbodbc10.dll” in the Value
data field.
•put a shortcut on the desktop for the
32-bit ODBC driver:
C:\Windows\SysWOW64\odbcad32.exe
•Check spelling on registry entries
Repeat step 3 except name it “Setup”.
Right-click “SQL Anywhere 10”, select New,
DWORD Value. Name it “UsageCount”. Press
Enter to edit the string. Enter “1” in the Value
data field.
Right-click "ODBC Drivers", select New, String
Value. Name it "SQL Anywhere 10". Press
Enter to edit the string. Enter "Installed" in the
Value data field.
Create an ODBC data source using this driver
if necessary
14
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Windows 7 Tips
•Have you found sticky notes yet on windows 7?
Start - Search ‘sticky notes’
•Hold down Ctrl and Shift while launching an application from the Taskbar or
start menu to launch it with full administrative rights
•Shake features – click and hold the title bar of the app you want open,
shake it
•Open command prompt to any folder - hold down the Shift key and rightclick a folder, then choose "Open command window here"
15
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Silly reminders
•Check to see if the backup is set and still running , weekly.
•Verify that the data being backed up is actually being backed up!
•Evaluate the free space on all drives of the server. ( C:\ and D:\ )
•Update your virus definitions and scan
•Plan purges.
•Plan for recoveries.
•Plan to install the next release of GlobalWare
16
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC
Thank you
To conclude:
Good Hardware Configuration
+
Routine Maintenance
=
A Healthy Database
Questions?
17
Keeping your Database Healthy
Copyright © 2010 Travelport, LLC