You are here:  Home / Blog / Categories / Uncategorized

Protect Your Data

Safe & Secure

Protecting Your DataMost people think of a “disaster” as something catastrophic and geographically widespread— an earthquake, fire, flood, or tornado, for example. Truth is, the disasters that cost global business the most don’t fit the traditional definition of catastrophe.

Contact Us

Please feel confident sending us an email, or giving us a call.contact-us
p: 403.695.1317
t: 1.855.667.1317
f: 403.770.8145
e: info@ravenbay.com
Blog entries categorized under Uncategorized

Uncategorized

Subscribe to this category 13 posts in this category
by Dion Dicks
Dion Dicks
http://www.ravenbay.com/company/our-team/dion-dicks.htm
User is currently offline
Tuesday, 20 December 2011 Category Uncategorized 0 Comment
Calgary Fire Fighters Toys for Tots 2011

On December 8th 2011, Raven Bay, IBM and our clients participated in this year’s Calgary Fire Fighters Toys for Tots campaign at local Calgary Fire Station #33.

Since 1967, Calgary firefighters host the largest Christmas party in Canada to benefit families in need. The firefighters collect all the toys across the city for the annual Children's Christmas Party at the Stampede Corral. More than 1,700 families are invited to attend this very special Christmas party. Once the guests arrive, they are treated to lunch, live entertainment and an exciting visit from Santa Clause. All children under 12 receive a gift from Santa as well as a bag of seasonal treats. In addition to all the Toys that were donated by Raven Bay team members, clients and partners, Raven Bay donated an additional $5000 to the Calgary Fire Fighters Toy Association. Check out our Toys for Tots afternoon at the fire station in the video at the following link:

 

http://www.ravenbay.com/company/community/calgary-firefighters-toys-for-tots-raven-bay-ibm-and-the-community.html

 

Tags: Untagged
Read More Hits: 330
0 vote

Oracle - Difference Between Dates in Different Rows

by Mathew Bruneau
Mathew Bruneau
Guest has not set their biography yet
User is currently offline
Wednesday, 09 November 2011 Category Uncategorized 0 Comment
Ever needed to know the difference between dates within groups of rows in Oracle?
An example:  you need to calculate the processing time between status' for a given invoice:

Transaction_Table
Invoice_ID Status Time_Stamp
1 Submit 2011-01-01 7:00:00am
1 Code 2011-01-01 9:00:00am
1 Approve 2011-01-01 1:00:00pm
1 Close 2011-01-02 7:00:00am
3 Submit 2011-01-01 7:05:00am


You may be inclined to do multiple joins back to the transaction_table to get the next status and subtract the dates, ie:

Select invoice_id,

(Invoice2.time_stamp - invoice1.time_stampe) * 24 as coded_time,

(Invoice3.time_stamp – invoice2.time_stamp) * 24 as approved_time,

(Invoice4.time_stamp – invoice3.time_stamp) * 24 as closed_time

From Transaction_table invoice1

Left join Transaction_table invoice2 on invoice1.invoice_id = invoice2.invoice_id

And invoice2.status = ‘Code’

Left join Transaction_table invoice3 on invoice1.invoice_id = invoice3.invoice_id

And invoice3.status = ‘Approve’

Left join Transaction_table invoice4 on invoice1.invoice_id = invoice4.invoice_id

And invoice4.status = ‘Close’

Where invoice1.status = ‘Submit’

Invoice_ID Coded_time Approved_time Closed_time
1 2 4 18
3 Null Null null


Oracle has provided two functions that can help alleviate these unnecessary joins.  The Lead() and Lag() functions were introduced to Oracle in version 8.1.6 making this query much simpler.
The Lead() function allows us to get the next row relative to the current row and the Lag() function allows us to get the previous row relative to the current row.

LAG  (value_expression [,offset] [,default]) OVER ([query_partition_clause] order_by_clause)

LEAD (value_expression [,offset] [,default]) OVER ([query_partition_clause] order_by_clause)


We can retrieve the same information in a more normalized form allowing the query to handle more status’ as they are added (ie, multiple approvals etc) and eliminate the joins.

Select invoice_id,

status

(time_stamp - lag(time_stamp,1,null) over (partition by invoice_id order by time_stamp)) * 24 as time

from transaction_table

Invoice_id Status Time
1 Submit Null
1 Code 2
1 Approve 3
1 Close 18
3 Submit Null
Tags: Data Warehouse, Oracle, Business Analytics, Business Intelligence
Read More Hits: 459
0 vote
by Dion Dicks
Dion Dicks
http://www.ravenbay.com/company/our-team/dion-dicks.htm
User is currently offline
Friday, 04 November 2011 Category Uncategorized 1 Comment

Welcome to Las Vegas

The IBM Information On Demand conference in Las Vegas, which ran from October 23 - 28, was pouring over the sides with valuable content and opening new opportunities.  The entire conference consisted of over 700 technical education sessions, industry-focused business & IT Leadership sessions, session content featuring software, hardware and services solutions, 110 hands on labs, 300 Customer speakers, IBM's largest EXPO, complimentary certification testing, IBM and industry-renowned speakers, and more than 10,000 attendees.  So out of all of this, what managed to stick?

 

Top 3 Take Aways


1. IBM Netezza 1000: It's hardware, its software, it's a data warehouse appliance, and it’s a storage appliance ... it's all of the above!  Because the IBM Netezza 1000 data warehouse appliance comes with preconfigured software and hardware it greatly reduces the amount of effort for a company to initiate its Business Intelligence initiatives.  This system can be put in within just days rather than months, and it just runs with very little hands on tinkering required.  Check it out on netezza.com (http://www.netezza.com/data-warehouse-appliance-products/twinfin.aspx). I almost forgot the best part, it comes in three colours!


2. IBM SPSS Statistics 20: Always wanted to be a fortune teller as a kid?  With predictive analytics in your organization and expertise in IBM SPSS you'll be the resident gypsy.  IBM SPSS is based on sophisticated statistical algorithms that have been about 30 years in the making, using similar technology to that used in IBM Watson for pattern recognition, allowing the models to "learn" from the source data.  IBM SPSS can be used for predicting future revenues, production levels, consumer satisfaction levels, or detecting fraud as it happens. http://www-01.ibm.com/software/analytics/spss

 

3. Jeff Jonas Key Note: Check out Jeff's presentation here, fast foward to the 20:00 mark:  http://www.livestream.com/ibmsoftware/video?clipId=pla_7c1b7dd6-feed-4352-9cb4-2abdea9c9751&utm_source=lslibrary&utm_medium=ui-thumb.  Great puzzle analogy of how business analytics and statistical analysis can be used to mess with your kids.

 

In addition to the education sessions IOD was a great opportunity to network with current and potential clients, IBMers and business partners alike.  Raven Bay hosted a Cognos roundtable for a small group of organizations to get together where they could talk about their own issues, challenges and successes with their business intelligence initiatives.  Representatives from a broad spectrum of industries were in attendance including oil and gas, commercial airline, energy, agri-business, and online payment processing.  Representatives brought perspectives to the table from the Sr. Analyst level to IT Director level.  For an overview of the experiences provided by Petrobank Energy and Resources Ltd have a look at their recent success story, http://www-01.ibm.com/software/success/cssdb.nsf/cs/STRD-8MXGJR.  The roundtable session went over really well with lots of great feedback.  Some very useful connections were made between clients in the Calgary area as a result.

Petrobank Story

Information On Demand was a great conference with loads of applicable content, some great presenters (some not so great, but there's always a few of those), and ample opportunity to build our skill set when it comes to Cognos and business intelligence in general.

 

Check out Jeff's presentation here, fast foward to the 20:00 mark,
Tags: Business Analytics, Business Intelligence, Cognos, Data Warehouse
Read More Hits: 460
0 vote
by Dion Dicks
Dion Dicks
http://www.ravenbay.com/company/our-team/dion-dicks.htm
User is currently offline
Friday, 02 September 2011 Category Uncategorized 0 Comment

 

One thing I have had to do during my records retention and information management project is lots and lots of research. Here are some of my favorite go-to sources.

AIIM.org:  

This site is chock-full of information and provides frequent up to date content via expert blogs and webinars from vendors and industry professionals alike. AIIM isn't specific to records management.  It combines the overlapping worlds of records management and enterprise content management into information management. If you read through a blog entry, be sure to visit the comments as well; this is where you’ll find the witty banter.

http://www.aiim.org/

ARMA.org:

Another great online resource, this one focusing more on records management principles. ARMA is closely tied with the Institute of Certified Records Management (ICRM) Professionals and has oodles of study materials for the CRM Certification exam.  Even if you’re not interested in the certification, ARMA has some great training materials and road show downloads that you can use to get your records management message out to your user community.

http://www.arma.org/

Canadian General Standards Board: Electronic Records as Documentary Evidence:

The Canadian Government Standard for electronic records.  If you’re not sure if your electronic records will stand up in a Canadian court this is the document for you.  Anyone who wants to ensure that their recorded information in their IT systems is trustworthy, reliable and authentic should use this standards document as their guide.

CAN/CGSB-72.34-2005 via www.techstreet.com

CANLII.org:

This is where you will find all the legal regulations, citations and legislation in Canada. Companies need to really know their business to weed through this stuff. Once you get the hang of it CANLII is an awesome resource for all your legal questions. A word of caution, where a citation is open to interpretation seek internal and / or external legal advice from the professionals.

http://www.canlii.org/

US Code of Federal Regulations and the United States Code via the US Government Printing Offices Federal Digital System (FDsys):

For Canadian companies with cross-border business in the US this resource is essentially the US de facto legal resource; the equivalent to CANLII.

http://www.gpo.gov/fdsys/

I have used many more resources while researching my current records retention and information management project.  These are the sources that I go to pretty regularly; almost on a daily basis.  I'm curious to know what others have had experience with.

Tags: Untagged
Read More Hits: 890
0 vote
by Fayon Redfern
Fayon Redfern
Guest has not set their biography yet
User is currently offline
Friday, 19 August 2011 Category Uncategorized 0 Comment

 

How important is a company’s culture to an employee?  “Culture” according to Wikipedia is “the set of shared attitudes, values, goals, and practices that characterizes an institution, organization or group”.    When looking at a new opportunity do we consider the culture of a company or do we focus more on what salary and company benefits are offered?

How do you know if your prospective company has the attitude, values, goals and practices that you are looking for? Do you look at the company’s employees or their clients?  Regardless of how you look at it initially, a company’s culture is just as important as the salary you are paid.  You are going to spend a considerable amount of your waking hours at work, so your work life is as important as your personal life.   You want to know that your career direction is aligned with those of your company. It is crucial that you and your co-workers share values and goals in order to have a positive culture regardless of what industry you are in.   Have those who are unhappy at work considered that maybe their company culture doesn’t fit them?

For me as an employee, our company culture provides an environment that is respectful, collaborative and career growth minded with a focus on work life balance.  I am confident that my peers will agree that these are just some of our shared sets of values. A company culture that is in sync with individual expectations is vital to a positive work environment.

Tags: Untagged
Read More Hits: 520
0 vote
by Dean Rowswell
Dean Rowswell
Guest has not set their biography yet
User is currently offline
Tuesday, 16 August 2011 Category Uncategorized 0 Comment

IBM Tivoli Monitoring is now included with AIX Enterprise Edition also included is Systems Director Enterprise Edition. Last week I was installing ITM for a customer and had a couple of installation issues that I also found fixes for.

DB2 Enterprise Server 9.7 with Fixpack 1 needs to be installed first. The db2setup program is used to start the graphical installer, but the installer wasn't launching. The tip for this is to run "export JAVA_COMPILER=none" before running db2setup.

TEMS (Tivoli Enterprise Monitoring Server) and TEPS (Tivoli Enterprise Portal Server) 6.2.2 with Fixpack 2 is installed next using the "install.sh" that is on the ITM base code DVD. During the initial configuration step for the TEPS (Tivoli Enterprise Portal Server) using the command "itmcmd config -A cq" the following error message was displayed: KCIIN0366E Failed to grant rights to itmuser

I downloaded and installed the ITM 6.2.2 Fixpack #5 update and re-ran the configuration step but it failed again with the same message.

There was also a newer Fixpack available for DB2 9.7. It is the Fixpack #4. I downloaded and installed this Fixpack. The db2level command now showed:

# db2level

DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09074" with level identifier "08050107". Informational tokens are "DB2 v9.7.0.4", "s110330", "IP23236", and Fix Pack "4".

Product is installed at "/opt/IBM/db2/V9.7".

This was the fix to this issue.  The TEPS configuration completed normally after this was done.

Tags: Untagged
Read More Hits: 948
0 vote
by Steve Wong
Steve Wong
Guest has not set their biography yet
User is currently offline
Wednesday, 10 August 2011 Category Uncategorized 0 Comment
Tags: Untagged
Read More Hits: 813
0 vote
by Dion Dicks
Dion Dicks
http://www.ravenbay.com/company/our-team/dion-dicks.htm
User is currently offline
Friday, 05 August 2011 Category Uncategorized 0 Comment

My last post was a bit of an overview of the current Records and Information Management (RIM) project I’ve been working on.  This one is a bit more detail on some of the challenges that are sure to be faced - consider this your warning if you’ve been asked to tackle your company’s non-existent records program.

5. You can’t please everyone, but you MUST!

With all the differing requirements from the different business areas, different divisional and operations offices around the world you will get some requirements and “nice to haves” that conflict with others.  Stick with the objectives outlined in the project or program charter.  Also leaning towards corporate objectives as opposed to user requirements will make the project more prevalent, BUT, user requirements cannot be ignored totally.  You won’t get users to adopt your program if they aren’t getting anything out of it.

4. HOARDERS!

Don’t be surprised when you find VP’s and Department heads with boxes piled up to their ceilings of old invoices and an Operations Manager with every email he’s ever sent and received for the past 20 years stored on CDs.  The higher up the chain you go the harder it will be but training and patience is the key when dealing with hoarders.

3. That minor in linguistics will finally come in handy.

Be prepared to decipher lingo from Accounting, Legal, IT, Tax, Accounts Payable, Accounts Receivable.  All groups will call the same thing something different and you need to identify those and consider this in any kind of taxonomy or classification scheme that you come up with.  Also, if you have division offices with their own accounting department they will likely call a PO something completely different that what Corporate Accounting calls it.

2. Quantifying the Good, justifying the Bad, and making a case for the Ugly.

Completing a Cost-Benefit Analysis and determining Return on Investment (ROI) are certainly great tools for explaining to Executives why they need a RIM initiative.  However, coming up with the numbers for things like how much time your payroll staff will save from no longer having to look for old boxes of payroll records, or how much more efficient your tax group will be once they have a defined electronic records structure, is easier said than done.  These are often considered “direct-soft benefits” with a disclaimer that the numerical value of this, if one was even provided, is difficult to determine.

1. Keeping Your Eyes on the Prize.

There are so many rules, regulations, laws, business requirements and overlapping initiatives when you are beginning to get into the weeds of a records and information management project/program.  So much so, it is often difficult to stay on top of what’s most important.  From a Project Manager’s perspective I say stick to the Charter.  This may seem obvious to some, but to others it can be a revelation that is your light at the end of a very long tunnel.  If you’re lucky enough to have a RIM Program or Department, stick to the Charter.  If you don’t have a Charter, get one, and get it signed by the Executive Sponsor ASAP.  Without agreed upon objectives you don’t have a prize to keep your eyes on in the first place.

There’s a heap load of other challenges to be faced.  This is some of the more notable challenges I’d expect to see on most RIM project or program initiatives.  If you have a different Top 5, do tell!

Tags: Untagged
Read More Hits: 390
0 vote
by Fayon Redfern
Fayon Redfern
Guest has not set their biography yet
User is currently offline
Wednesday, 03 August 2011 Category Uncategorized 0 Comment

As an IBM premier business partner, Raven Bay is invited to many IBM technology briefings.   I recently attended an interesting session regarding IBM’s Tivoli Endpoint Manager which leverages IBM’s latest “Big Fix” acquisition.  This software suite focuses on four key areas:

  • Are organizations aware of all endpoints in their IT environment?
  • Does security reach across all of the organization’s endpoints?
  • Does the organization’s patch management process protect from the latest threats?
  • How can power management be leveraged while minimizing end user impact and supporting “corporate social responsibility” by reducing Co2 emissions?

IBM’s Tivoli Endpoint Manager (TEM) provides lifecycle management, security and compliance, patch management and power management modules which can be deployed quickly and without impacting the bandwidth of the enterprise.  

TEM software is loaded as an agent on every end point (perfect for complex and diverse IT environments) and is managed through a common console on a dedicated TEM server.  The ratio of server to endpoints is one server for every 250,000 endpoints.

For more detailed information regarding Tivoli Endpoint Manager and the four modules, please refer to IBM’s website:

http://www-142.ibm.com/software/products/ca/en/endpointmanager/

Tags: Untagged
Read More Hits: 339
0 vote
by Brian Ung
Brian Ung
Guest has not set their biography yet
User is currently offline
Friday, 08 July 2011 Category Uncategorized 0 Comment

Issue: Select statement sessions are getting hung up.

When running TSM version 6.1 or 6.2 your TSM is likely running fine until you delete a node. The next day, you go through your daily checklist and notice that you have a lot of sessions running. You try to cancel the sessions and they will not cancel. The reason has been found that deleting a node has triggered a session hang problem. IBM has recently released a solution. To fix the problem you will need to apply the fix level 6.1.4.5 or 6.2.2.2 depending on which version you are running.

The fix levels are now available and can be downloaded at:

ftp://ftp.software.ibm.com/storage/tivoli-storage-management/patches/server/

 

Tags: Untagged
Read More Hits: 612
0 vote
by Dean Rowswell
Dean Rowswell
Guest has not set their biography yet
User is currently offline
Friday, 08 July 2011 Category Uncategorized 1 Comment

 

          There are problems with the latest version of PowerHA 7.1 software with the latest fixes (SP3) from December 2010. This is the first version of the popular IBM clustering software for AIX which takes advantage of CAA (Cluster Aware AIX). CAA is available on the AIX 6.1 TL6 and AIX 7.1 TL0 base media. After installing a new cluster and attempting a start of the cluster the first node came up fine but the second one did not.  A simple reboot was necessary to get the second node to start. Once both nodes were up and running the halt command was used to failover the resource group to the second node.  It took about 1.5 minutes for the failover to work.  This is longer than expected since this new version is supposed to detect node failure faster. Once the first node came back up it didn't join the cluster and then the second node crashed!  After restarting the second node it didn't join the cluster either. At this point PowerHA 7.1 was removed and PowerHA 6.1 (with SP5) was installed.  This version worked flawlessly. We are looking forward to re-testing these scenarios when PowerHA 7.1 SP4 is available.

 

** October 28, 2011 - Update**

"I have been able to work with PowerHA 7.1 SP4 and AIX 6.1 TL6 SP5.  This combination is now working great.  The previous problems have now been fixed. 

CAA has been updated with the newer Service Pack for AIX.  This was the key to the stability of the PowerHA 7.1 cluster"

***

Tags: Untagged
Read More Hits: 745
0 vote
by Dion Dicks
Dion Dicks
http://www.ravenbay.com/company/our-team/dion-dicks.htm
User is currently offline
Thursday, 23 June 2011 Category Uncategorized 0 Comment

Growing companies that go through consistent internal growth and acquisitions, generate an enormous amount of records during the course of business.  The volume of these records for any given company is growing exponentially.  In the light of new and more frequent e-discovery requests, the time has come for a lot of these companies with no formal policy to address how long records need to be retained.  This has led to a multi-year records retention and information management project where Raven Bay is assigned to manage this project for one of our clients.

With the rising cost of physical storage, due to outsourced providers, legal departments are concerned that some critical records might be destroyed earlier than they should. Other records are retained longer than they should be which could be used in legal discovery action. All contribute to the impact of ineffective records management and create corporate risk. In the initiative by our client to reduce these risks, Raven Bay and the Legal Department teamed up with IT to analyze the business records. We’ve come up with a suitable records retention policy and records retention schedule to mitigate these risks.

The first phase of the project was to determine what record types are used within the business. Discussing with employees at all levels of the business, we found out what's out there.  Next step was to obtain some legal research from outside experts as to what legislation, statutes and regulations exist that might be applicable to the client's business. With a detailed inventory of existing record types, plus the list of legal citations the client's, records were then matched to the legislation.  The client confirmed if they agreed with the suggested retention periods or revised them to meet any operational business needs.

Raven Bay's Project Manager and the VP of legal used a guideline for the policy provided by the external legal advisors and compared it to the two available ISO standards on records management as well as other records management best practice documentation.  The result was a records retention policy that the client's executive team could hang their hat on.

About seven months after the initial roll out the various departments have felt empowered to destroy copious amounts of documentation that have outlived their useful life while still retaining the company’s vital records.  Training materials were created by Raven Bay and delivered by the company’s Legal team and was well received with representatives from all functional areas in Canada and the US.

The project continues today with a more focused approach to electronic records management where the ultimate goal is solution investigation for ensuring policy compliance at the electronic records level including network files and emails.

Tags: Untagged
Read More Hits: 506
0 vote
by Steve Wong
Steve Wong
Guest has not set their biography yet
User is currently offline
Thursday, 23 June 2011 Category Uncategorized 0 Comment

Cisco Unity server is a flexible tool which an Administrator can use to easily provide unique services for the Business sector. One such service has been discovered when a problem was presented regarding a business phone conversation turned hostile. Subsequently, I was asked if there were any way to record and archive a live conversation for possible future legalities. After some research, I was able to configure a built-in feature of the Cisco Unity software called Live Record.

The Live Record feature is a great tool that allows the user to save a recorded message/conversation to his or her voice mailbox. The only drawback of this feature is that it is dependent on the phone model for the ability to program one of the phone’s option buttons to automatically dial the routing number that initiates the recording. The client is currently using the Cisco 7945 models for their offices which made this not possible, a programmed speed dial was the alternative solution.   

Once Live Record was setup, I found a way to archive the recorded messages to a network repository which is where the Cisco Unity email client integration comes in. My client is using MS Outlook, although it would need to be tested, it is likely that Unity integrates with Lotus Notes in the same manner. By setting up an IMAP account and directing my voicemail account to Exchange, I was able to view the recordings as WAV files and save them to any network location.

There is also a plug-in for the email client called ViewMail. By installing this plug-in the user has access to create and listen to voice messages, all within the email client. This added feature currently serves the purpose of turning your phone into a personal voice recorder. Who knows what new situations may arise that a business may request such a service?

It is also notable that this solution and feature is not intended solely for recording disagreeable phone dialogues. I was also asked to prepare a solution for the Marketing department so that they could make business deals on the phone, record and archive them, and later share them among the department as required.

By combining several features from a Cisco Unity server, this solution shows how Raven Bay can use the available technologies and add-ins to give our clients the results they require to suit their business needs, today and in the future.

 

N.B. Please note that it is imperative to always follow company policies and ensure legal regulations are followed, pertaining to privacy rights and confidentiality for any voice recording.

Tags: Untagged
Read More Hits: 236
0 vote

Developed by  Late Night Tonight Live