Archive for the 'DB2 pureXML' Category

Live at CASCON 2006

Tuesday, October 17th, 2006

CASCON Technology ShowcaseAfter my yesterdays participation in the workshop DB2 XML – A True XML and Relational Database, the rest of the week will be spent at the CASCON Technology Showcase, with a poster and a some live demos aout DB2 9 pureXML™.

Yesterday’s workshop as a success! The room was completely full and we even had some people having lunch in the meeting room just to have more time to explore the project and ask us questions. My session was the first in the afternoon, entitled "XML Indexing in DB2", with a 30 minute presentation plus 40 minutes of lab exercises. As my first experience lecturing at a workshop, it was interesting to be on the other side and feel the responsability (and excitment) of having about 40 people staring at us and asking questions. Most of the public in our workshop were wither DB Appllication developers or students in the database field.

Note 1: for as much that you prepare a presentation, there will be always some question that you don’t expect, and that if have no idea what’s the correct answer.

Note 2: for as much that you prepare the lab exercises, there will always be a typo on it ;-) Nothing serious.. just a "$d" not escaped being consumed by the linux command line.

Note 3: the food at Hilton is great!

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)
VN:F [1.8.1_1037]
Rating: 0 (from 0 votes)

Popularity: 7% [?]

My new distant Home

Wednesday, September 27th, 2006

IBM Toronto Lab12 hours of flight can be transformed into 32 hours of travelling, if you have to "visit" 4 airports and one of the flights gets delayed, making you spend the night at the airport waiting for a connection flight. The (not!) awesome United Airlines declined to pay for a hotel room for the about 50 people with lost connections, because, according to them, the delay "was in the taxi way, so it’s not our fault". Well, for some reason that wasn’t explained, the airplane left the gate in direction to the taxi way almost one hour late. Considering that my connection was 15 minutes after our arrival to Washingotn Dulles Airport, that hour would have been enough for me!

After leaving Carapeços (Barcelos, Portugal) at 8:00h of September 25, I just arrived Toronto (Canada) at 11h30 of September 26.

I’ll be in the Toronto area for one year, enjoying the freezing weather of Canada, and also enjoying my work at IBM Canada, working as a technology enabler for DB2 9 pureXML™.

1st impressions:

  • traffic is hell! Even worse than Los Angeles.
  • The streets/houses are old and not taken care off.
  • the IBM lab is just beautifull, and with excellent conditions.
  • I need to get a network cable, because the wireless signal in my office is very weak…

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)
VN:F [1.8.1_1037]
Rating: 0 (from 0 votes)

Popularity: 17% [?]

CASCON 2006

Wednesday, September 6th, 2006

CASCON 2006 wil take place from October 16 to October 19, in Toronto, Canada. 

"CASCON 2006 is the 16th in the Annual International Conference hosted
by the IBM Centers for Advanced Studies. This "Meeting of Minds"
provides an exciting forum for exchanging ideas and experiences in the
ever-expanding and critical fields of software development and
computing."

I will be presenting at CASCON, doing both a workshop and a technology showcase. Both sessions will be about the same subject: DB2 9 and it’s pureXML™ features.

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)
VN:F [1.8.1_1037]
Rating: 0 (from 0 votes)

Popularity: 5% [?]

DBI1082E error message when creating new DB2 instance

Tuesday, September 5th, 2006

I recently spent a few hours at work trying to understand why I was receiving the DB2 error message with code DBI1082E.
After
I installed DB2 on an AIX machine, I needed to create an instance. When
running "db2icrt vrodrig", I got this error. The error message was:
DBI1082E

The file or directory /home/vrodrig/sqllib already exists.

At
the first time I hit the error, the solution was obvious: just go and
delete the folder, that existed because of a previous DB2 installation.
However, the error persisted. And even more funny, there was a new
/home/vrodrig/sqllib folder being created every time I ran "db2icrt
vrodrig". This was strange. I deleted the folder before running
db2icrt, but when running the command, it would always fail, and there
would be a new

/home/vrodrig/sqllib folder there. So, the symptom was something like:
sqllib folder is only created when db2icrt is ran, but db2icrt fails
because sqllib already exists.


After searching on google, only one link revealed itself of some interest and usefullness. It was this post at developerWorks.
 Although
the post didn’t had the solution for my problem, it had some ideas that
led me to fix the problem. And the problem was that because I was
logging in to the system with the user id vrodrig, there was already a
db2profile file from the previous installation being sourced at login
time. This would cause the actual db2 installation to write some stuff
to

/home/vrodrig/sqllib even before creating the instance. To fix the
problem, just login to the system with a different user, then "su" to
root, delete the folder
/home/vrodrig/sqllib, run "db2icrt vrodrig" and voila, you are done! (Note: replace vrodrig and /home/vrodrig/sqllib with your user id and sqllib folder).


Just
as a side note, either this is not a very common error, or there isn’t
that many information about DB2 out there. I found just one link
talking about the same problem.

VN:F [1.8.1_1037]
Rating: 10.0/10 (1 vote cast)
VN:F [1.8.1_1037]
Rating: +1 (from 1 vote)

Popularity: 22% [?]