Hi,
I am using db v9.5 ESE on windows.

Default View 'Snapappl_info' defined while creating database is defined as:
CREATE VIEW SYSIBMADM.SNAPAPPL_INFO (snapshot_timestamp, agent_id, ...) AS SELECT snapshot_timestamp, ..., is_system_appl FROM TABLE(SYSPROC.SNAP_GET_APPL_INFO_V95('')) as T

but i can find no table with name this view is using, so where is the information in view being fetched from?

SNAP_GET_APPL_INFO_V95() is a so-called table function: it returns a table.
That explains the keyword TABLE: "from" expects a table/view/nested select, not a function.
Since that function is in the SYSPROC schema, it should be documented in the DB2 SQL manuals under the section "table functions". (Didn't verify, though.)

thanks peter!