After playing around with the DB2 Adapter, I discovered that DB2, as expected, has its own unique syntax for SQL statements. Not so great if you come from the SQL server background.

SQL Syntax: Select top 10 * from [TABLE]

What is this in db2 SQL?

Select * from [TABLE] FETCH FIRST 10 ROWS ONLY

Many thanks to: http://en.wikipedia.org/wiki/Select_(SQL)

Have you ever received the following error Message When using the db2 Adapter for BizTalk? The adapter "DB2 Adapter" raised an error message. Details "UPDATE or DELETE is not allowed against the specified cursor. SQLSTATE: 42828, SQLCODE: -510"   more »

Creates compiled help files for a given BTS 2006 installation. This tool can be run on an ad-hoc basis using the UI or from the command line as a post build/deploy task to create a compiled help file describing a BTS 2006 installation.   more »

How to clean up all of the backupfiles created with the BizTalk Backup Job As anyone who has fully implemented BizTalk will know, if you do not backup your databases you will have problems. I can not stress more highly, please back up your BiTalk databases. The next thing you will notice is that its not that simple, there is a Backup Job that ships with the product, that creates backups, you NEED to use this job to create your backups or you will not be supported. The job will create a full backup daily, and a transactional log backup every 15 minutes. (This is configurable) At the end of the day, you end up with quite a lot of files, that take up quite a lot of disk space depending on how active your solution has been. In reality you should be archiving these backups daily, and cleaning up the backup directory. But what if your backup directory is on the SAN and its backuped up, but there are several days worth of backup still lying around… This happens more often than you would think, so we have 100’s of these backup files filling up the disk, which gets critical when the disk fills up. So how do I clean up these files automatically.......   more »

I have decided that, as I come across errors in what I do related to BizTalk, I will document how I overcame these errors. So in fix the error lesson 1, we had a problem running config frame work on BizTalk 2006. The error was very vague: ERROR: 0x80070002 : The system cannot find the file specified.   more »

The envelope processor is fantastic, it will allow you to receive a document is several records in it, and split it out automatically, into several little messages. All you need to do is define your envelope, and then your child message schema. Lets get it to work with the Oracle adapter that comes with BizTalk 2006...   more »

It appears that Microsoft released BizTalk 2006, check it out: HERE

I am pleased, and surprised at the same time, I have been pushing to find out when this would occur, and there it happens right under our noses.

I have been having some major problems with the RC release, however I am keen to check the RTM out, and see how it fly’s, hopefully these bugs have been ironed out.....

All in all I must say it is an impressive upgrade to BizTalk 2004, and I can say that the new things in there WILL make life easier, and hopefully increase the use of Best Practice.

POST BizTalk 2006, look out for an enhancement release for all the cool bits that didn't make the release, as they are very cool indeed.