DB2 Students Group

Foi lançada uma nova versão do DB2!

Entre as novidades destaca-se:

• Um footprint 37% mais leve no download para Windows ou Linux;
• Possibilidade de guardar padrões de reconhecimento de texto em condições do tipo LIKE nas colunas da base de dados;
• Indexamento mais rápido e pesquisas mais poderosas com o DB2 Text Search;
• Compound triggers para UPDATE, INSERT, e DELETE.

Fonte: DB2 Express-C Team Blog

MediaWiki is the wiki application that underlies Wikipedia and many other websites. It is written in PHP and licensed as open source under the GPL. Historically, it has run on MySQL, but it does have a sophisticated database abstraction layer that provides support for PostgreSQL, IBM DB2, and other databases.

Our main goals for this project are to:

• integrate DB2 support with the new MediaWiki installer being developed for the 1.17release;
• debug the core wiki functionality on DB2;
• implement search, possibly taking advantage of DB2’s Full Text Search features.

This project is being developed by André, César, Daniel and Diego.

O grupo de embaixadores DB2 da Universidade do Minho foi renovada. Contamos agora com os novos elementos:

• André Barbosa;
• César Abreu;
• Daniel Oliveira;
• Diego Albuquerque;
• José Silva;
• Vitor Costa.

Esperemos estar à altura do desafio e continuar o excelente trabalho dos nosso antecessores.

Mais informações aqui.

A IBM acabou de anunciar uma nova versão do DB2

1. Imensas melhorias em termos de performance.
2. Melhor gestão automática da base de dados, menos necessidade de DBA.
3. Melhor compressão de XML (inlined).
4. Compressão de indexes e de documentos XML no XDA.
5. Suporte de XML em datawarehousing.
6. Suporte do tipo de dados XML em stored procedures.

Data Studio Developer provides a complete development and testing environment for building database objects, queries, database logic, and pureQuery applications.

IBM Data Studio Developer 1.2 was official released at August 1st.

IBM Data Studio is a useful tool for DB2 developers/users and can be downloaded here.

For more information about IBM Data Studio see the official website here.

Enjoy!

Originally posted at:

• http://nunojob.wordpress.com/2008/02/26/
  mets-standard-with-ibm-db2-express-c-
  using-xforms-as-user-interface-and-ruby-on-rails-as-a-rest-web-services

Boas noticias chegam do blog DB2 Express-C onde já é possível a totalidade do workshop DB2 on Campus sem precisar de sair de casa. Excelentes noticias para todos nos, especialmente porque vai permitir aos embaixadores prepararem com maior facilidade o evento para o próximo semestre.

Some users are getting the following error when installing DB2 Express-C in Ubuntu 7.10

ERROR:
The required library file libstdc++.so.5 is not found on the system.
ERROR:
The required library file libaio.so.1 is not found on the system.
Check the following web site for the up-to-date system requirements
of IBM DB2 9.5

http://www.ibm.com/software/data/db2/udb/sysreqs.html

http://www.software.ibm.com/data/db2/linux/validate

/home/antonio/Desktop/exp/db2/linux/install/../bin/db2usrinf:
error while loading shared libraries: libstdc++.so.5:
cannot open shared object file: No such file or directory
[: 609: 0: unexpected operator
/home/antonio/Desktop/exp/db2/linux/install/../bin/db2langdir:
error while loading shared libraries: libstdc++.so.5:
cannot open shared object file: No such file or directory
/home/antonio/Desktop/exp/db2/linux/install/../bin/db2langdir:
error while loading shared libraries: libstdc++.so.5:
cannot open shared object file: No such file or directory
DBI1055E The message file db2install.cat cannot be found.

Explanation: The message file required by this
script is missing from the system; it may have been
deleted or the database products may have been loaded
incorrectly.

User Response: Verify that the product option containing
the message file is installed correctly. If there are
verification errors; reinstall the product option.

To fix this you only need to get libstdc++5.
Just put this 3 lines in your console and your ready to go.

sudo apt-get install libstdc++5
sudo apt-get install libaio-dev
sudo ./db2setup

A new version of DB2 Express-C was made available by IBM today. As you might already know DB2 Express-C is a free dataserver without any limits on database size or number of users.

We got this news from Antonio Cangiano, a IBM Engineer that likes DB2 and Ruby on Rails. Seems like a nice guy!

So you won’t find this new version on IBM DB2 Express-C Website, but you can download the Linux Version here and the Windows Version here. Mac version is still not available. This is probably the down side as many of us are waiting for IBM to ship a Express-C DB2 version for Macintosh. Hopefully next time?

We still didn’t tested the new DB2 but according to Antonio

Version 9.5 brings to the table a great deal of new enhancements and features. Among these there is also the reduced amount of memory requirements and the improved efficiency of operations on Linux. Oh and it will also make you rich and more beautiful. I mean, pureXML support has been greatly improved and it is a release that is sure to please many people on both Windows and Linux.

About the T-Shirt, we know it’s great. Hopefully Vítor will send us some few.

O DB2 Student Ambassador Program tem como objectivo captar alunos interessados em DB2 que se queiram tornar “embaixadores” na sua universidade. Além do contacto directo com a equipa do DB2 Express-C durante o período em que exercerem as funções (mínimo de 6 meses), os alunos que forem embaixadores receberão uma carta de recomendação da IBM que poderão usar junto com o seu currículo.Esta é uma iniciativa excelente para os alunos interessados se envolverem com o mundo profissional e exporem-se a possíveis oportunidades na IBM (tal como tem acontecido a estudantes de Brasil e Alemanha, os países mais activos nesta iniciativa).

Os alunos interessados em mais informações sobre o programa ou que se pretendem candidatar a DB2 Student Ambassador podem devem visitar a página oficial do programa.