Tuesday, June 1, 2010

Intergy Backup Restore Checklist

I’ve been restoring our Intergy database on Progress and I developed this checklist below to help define the process. I read the Checklist Manifesto and found the overall message really applicable to IT tasks. 

Intergy Backup Restore Checklist

r 1. Is the medman.odbk file from the previous date on the Intergy Backup Server (INTBKPSRV)

o    If NO find it on \\192.168.3.200\share\int_bkp and move to INTBKPSRV.

r 2. Copy AI files from Production server to AI drive on INTBKPSRV

r 3. Confirm that drive structure matches production environment

o    D = AI

o    E = BI

o    F = DB

r 4. Before Installing run (install.exe user \) prior to running the setup.exe for Intergy.

r 5. Install Intergy Server (Point DB to drive F)

o    EHR

o    Storage Server

o    Patient Portal

o    > 50 Users

r 6. AI & BI file locations: During installation you must point Intergy toward the appropriate drives for where this data will reside. (See step 2)

r 7. After Server Restart Launch Database Administration

r 8. Choose Enterprise 80 GB

r 9. Redirect the AI, BI and DB to the correct drive paths

r 10. Navigate in Command Prompt to c:\intergy\db to run all commands

r 11. Intergy large File Support: To add support for larger than 2GB storage area files, run the following command:

o    PROUTIL medman –C enablelargefiles

r 12. Consult the medman.lg file for detailed information concerning the database.

r 13. Shutdown Database: promon medman Option 8 then Option 2

r 14. VERIFY DATABASE: prorest medman D:\IntergyBackup\medman.odbk –vp

r 15. DELETE DATABASE FILES: prodel medman

r 16. RESTORE DATABASE: prorest medman D:\IntergyBackup\medman.odbk

r 17. Launch “Database Administration” and Start the database.

r 18. Run Intergy, Intergy EHR and Test

ROLL FORWARD

r 19. RESTORE FILES FROM LAST BACKUP: rfutil medman –C roll forward –a <afile#>

r 20. ENABLE AI: rfutil medman –C aimage begin

POST RESTORE STEPS

r 21. Verify Cluster size: proutil medman –C truncate bi 16384

r 22. Verify AI is enabled: rfutil medman –C aimage extent list

r 23. RESTART SERVER (After restart review the medman.lg file to ensure proper database start up.

Restore database without loading Intergy

r Repeat Steps 12 through 18


Intergy Testing

r Login to 10 random Data Sets

r Check patient demographic data in Intergy PM and Intergy EHR.

r Check patient billing data in Intergy PM

r View EOB image from DOM

r Print Encounter form

r Print Schedule Summary for the day

r Change patient demographic and billing data

r Make a backup of new changed database. (45 min)

r Restore original database and have Operations validate that data is gone. (45 min)

r Restore changed database and have Operations validate that data is restored. (45 min)

Orencio Cárdenas

IT Manager

Femwell

Tel.# 305-273-4641 X141

Tel.# 305-631-7670 Help Desk

Cell# 786-566-8457

Posted via email from Orencio's posterous

Thursday, May 20, 2010

Karate Kid - Mr Han is no Miaghi

Good movie that is worth seeing. Story mirrors the original. Mr. Han is the new Mr. Miaghi but not as good. Tournament fight scenes were awesome. 

Posted via email from Orencio's posterous

Tuesday, May 4, 2010

Setting up Dell Equlogic

Got all the gear in for setting up a productio and staging environment. Working on Dell storage now.

Posted via email from Orencio's posterous

Wednesday, March 17, 2010

Pivot Software - Must Watch

This is a very cool software that presents data in a fresh and visual way. I downloaded it after and it was every bit as cool as the presentation.

Posted via email from Orencio's posterous

Saturday, March 6, 2010

What customer information is at your fingertips?

What are the products you are offering that your customers are buying? From
the content of your data, can you tell what your customers are interested
in? What part of your data would be most relevant for determining potential
future products and services? What are you doing with that data? Can your
data tell you what is changing about your customers purchasing history?
What assumptions can you make about your customers? How do certain customer
segments use your services or products?

Take a long hard look at the information you have collected to date.
Understanding this data and what it tells you about your customers and their
purchasing practices is critical to business sustainability. If you have
gaps of information, think about what other types of information you can
collect that would be useful to your business. This information will be
critical to planning your future business strategies and tactics. You need
to keep learning about your customers, the market and what is selling.
Understanding what is selling and how it is selling is important to you and
your business.

But customer information isn't the only critical information you own. Data
related to product production and purchasing becomes key for your business
operations. How you use resources to bring products and services to market
matters to the bottomline. Understanding when you are paying too much for
something or wasting resources becomes critical to minimizing expenses and
maximizing profits. Therefore analyzing this data is just as important as
analyzing customer information.

So in the end, you need to ask yourself what customer and operational
information do you have at your fingertips? If you aren't able to get
valuable information about your customers or business operations from your
data, then you need to get someone to do it for you or outsource it but
don't just let that information sit there untapped and unused because it
could mean the difference between a successful business or no business.=

Posted via email from crunchthisinfo's posterous

Friday, February 5, 2010

Social Networks and Medical Organizations

Great website that highlights how Hospitals are using Social Networks.  It’s interesting to see that from the 31 state, in patient hospitals listed with You Tube, Facebook and Twitter only 4 are in Miami.

http://ebennett.org/hsnl/

Outsourcing Social Media Efforts may not work because people are interested in having authentic communications through social media not just a “please hold” script.

Posted via email from Orencio's posterous