How do we enable the table for filtering mode in DB2 same as informix?

ahmedwaseem2000, can you explain a little more about what you need. I am not familiar with Informix and and don't know what table filtering is in relation to it.

I mean at times when we have to do a bulk load and to avoid the load failures we enable the constraint mode to filter which would write all the records that fail a constraint to an error table. So, I was just curious if there is something similar like this in DB2

Yes, there is. Download manual. It is there.

could you please give me the reference to the manual???

Sure thing

IBM - DB2 9.1 for Linux, UNIX and Windows manuals

the one that you are looking for specifically is "Command Reference", but do not neglect others.

Here is a link to the IBM - DB2 Version 9.5 for Linux, UNIX and Windows English manuals. I believe you want the Command Reference manual.

There is a similar capability in DB2, although it is not a table property but rather an option that you can choose when running a LOAD command or enable the referential integrity by SET INTEGRITY. Exceptions then will be moved into an exception table instead of causing the command to fail. You will find details in the manuals, the link to which has been already provided.