Dear all i am working on AIX 5.3, DB2 8.1.7,

$ db2 -tvf reorg_Test.db2

DB21007E End of file reached while reading the command.

Were test is my db name,where as if i am using same process for another db, its working successfully.

can anybody tell me what is the mistake i am coming across.
Thnx in advance..........................

Each Statement needs a ";" at the end.

Thnx for your reply, i am forget to mention that one , even after using ; it is showing same error.
My file contains following data , pls check once.


$ cat reorg_test.db2
reorg table COMMUNITY.ACTION_DESC;
reorg table COMMUNITY.ACTION_DESC_LOD;
reorg table COMMUNITY.ACTION_SET;
reorg table COMMUNITY.ACTION_SET_LOD;
reorg table COMMUNITY.APP_DESC;
reorg table COMMUNITY.APP_DESC_DD;
reorg table COMMUNITY.APP_DESC_LOD;
reorg table COMMUNITY.APPLICATION_ROLE;
reorg table COMMUNITY.APPROLE_LOD;
reorg table COMMUNITY.CDO_ACLENTRY;
reorg table COMMUNITY.CDO_ATTRIB;
reorg table COMMUNITY.CDO_ATTRIB_DEF;
reorg table COMMUNITY.CDO_CATEGORY;
reorg table COMMUNITY.CDO_CATEGORY_LOC;
reorg table COMMUNITY.CDO_CDO;
reorg table COMMUNITY.CDO_CDO_LOC;
reorg table COMMUNITY.CDO_CDO_POV;
reorg table COMMUNITY.CDO_FAVORITES;
reorg table COMMUNITY.CDO_VERSIONINFO;
reorg table COMMUNITY.CLIENT_DESC;
reorg table COMMUNITY.CLIENT_DESC_CAPS;
reorg table COMMUNITY.CO_CMTY;
reorg table COMMUNITY.CO_CMTY_LOC;
reorg table COMMUNITY.CO_CMTY_ROLE;
reorg table COMMUNITY.CO_CMTY_ROLE_LOC;
reorg table COMMUNITY.CO_CMTY_ROLE_MAP;
reorg table COMMUNITY.CO_DOM_OBJ;
reorg table COMMUNITY.CO_MEMBER;
reorg table COMMUNITY.CO_MEMBER_ROLE;
reorg table COMMUNITY.COMP_INST;
reorg table COMMUNITY.COMP_INST_DD;
reorg table COMMUNITY.COMP_INST_MAD;
reorg table COMMUNITY.CRED_SEGMENT;
reorg table COMMUNITY.CRED_SLOT;
reorg table COMMUNITY.CRED_SLOT_LOD;
reorg table COMMUNITY.CTX_CLBCTX;
reorg table COMMUNITY.CTX_DMNOBJREF;
reorg table COMMUNITY.CTX_VERSIONINFO;
reorg table COMMUNITY.EVT_HANDLER;
reorg table COMMUNITY.EVT_INTERFACE;
reorg table COMMUNITY.LANG_DESC;
reorg table COMMUNITY.LANG_DESC_LOD;
reorg table COMMUNITY.LNK_APPROLE_ROLE;
reorg table COMMUNITY.LNK_PAGE_PORT;
reorg table COMMUNITY.LNK_RES_TYPE_AS;
reorg table COMMUNITY.LNK_RES_TYPE_RES;
reorg table COMMUNITY.LNK_RESTYPE;
reorg table COMMUNITY.LNK_THEME_SKIN;
reorg table COMMUNITY.LNK_USER_APPROLE;
reorg table COMMUNITY.LNK_USER_ROLE;
reorg table COMMUNITY.MARKUP_DESC;
reorg table COMMUNITY.MARKUP_DESC_LOD;
reorg table COMMUNITY.PAGE_ACT_ASC;
reorg table COMMUNITY.PAGE_ACT_ASC_LOD;
reorg table COMMUNITY.PAGE_INST;
reorg table COMMUNITY.PAGE_INST_DD;
reorg table COMMUNITY.PAGE_INST_LOD;
reorg table COMMUNITY.PAGE_INST_MAD;
reorg table COMMUNITY.PBS_BINDER;
reorg table COMMUNITY.PBS_PROPERTIES;
reorg table COMMUNITY.PBS_WIRES;
reorg table COMMUNITY.PORT_ACT;
reorg table COMMUNITY.PORT_ACT_DD;
reorg table COMMUNITY.PORT_ACT_LOD;
reorg table COMMUNITY.PORT_ACT_MD;
reorg table COMMUNITY.PORT_DESC;
reorg table COMMUNITY.PORT_DESC_DD;
reorg table COMMUNITY.PORT_DESC_LOD;
reorg table COMMUNITY.PORT_DESC_PREF;
reorg table COMMUNITY.PORT_INST;
reorg table COMMUNITY.PORT_INST_PREF;
reorg table COMMUNITY.PORT_PARM;
reorg table COMMUNITY.PORT_PARM_LOD;
reorg table COMMUNITY.PORT_PROP;
reorg table COMMUNITY.PORT_PROP_LOD;
reorg table COMMUNITY.PORT_WIRE;
reorg table COMMUNITY.PORT_WIRE_DD;
reorg table COMMUNITY.PORT_WIRE_LOD;
reorg table COMMUNITY.PORT_WIRE_MD;
reorg table COMMUNITY.PORTAL_URL;
reorg table COMMUNITY.PORTAL_URL_DD;
reorg table COMMUNITY.PROT_RES;
reorg table COMMUNITY.PSE_CATEGORY;
reorg table COMMUNITY.PSE_CATEGORY_DD;
reorg table COMMUNITY.PSE_CATEGORY_LOD;
reorg table COMMUNITY.PSE_DESC;
reorg table COMMUNITY.PSE_DESC_DD;
reorg table COMMUNITY.PSE_SOURCE;
reorg table COMMUNITY.PSE_SOURCE_DD;
reorg table COMMUNITY.PSE_SOURCE_LOD;
reorg table COMMUNITY.RES_TYPE;
reorg table COMMUNITY.RES_TYPE_LOD;
reorg table COMMUNITY.ROLE_INST;
reorg table COMMUNITY.SEC_CONSTR;
reorg table COMMUNITY.SEC_ROLE_REF;
reorg table COMMUNITY.SERV_DESC;
reorg table COMMUNITY.SERV_DESC_DD;
reorg table COMMUNITY.SERV_DESC_MAD;
reorg table COMMUNITY.SERVER_INFO;
reorg table COMMUNITY.SERVER_INFO_DD;
reorg table COMMUNITY.SERVER_INFO_LOD;
reorg table COMMUNITY.SKIN_DESC;
reorg table COMMUNITY.SKIN_DESC_DD;
reorg table COMMUNITY.SKIN_DESC_LOD;
reorg table COMMUNITY.SKIN_DESC_MAD;
reorg table COMMUNITY.THEME_DESC;
reorg table COMMUNITY.THEME_DESC_DD;
reorg table COMMUNITY.THEME_DESC_LOD;
reorg table COMMUNITY.THEME_DESC_MAD;
reorg table COMMUNITY.UDDI_REG_DESC;
reorg table COMMUNITY.UDDI_REG_DESC_LOD;
reorg table COMMUNITY.UDDI_REG_DESC_PD;
reorg table COMMUNITY.UDDI_REG_DESC_TMK;
reorg table COMMUNITY.UNIQUE_NAME;
reorg table COMMUNITY.URL_MAP_CTX;
reorg table COMMUNITY.URL_MAP_CTX_LBLS;
reorg table COMMUNITY.USER_DESC;
reorg table COMMUNITY.USER_DESC_STATE;
reorg table COMMUNITY.VAULT_DATA;
reorg table COMMUNITY.VAULT_RESOURCES;
reorg table COMMUNITY.VP_DESC;
reorg table COMMUNITY.VP_DESC_LOD;
reorg table COMMUNITY.WEB_MOD;
reorg table COMMUNITY.WEB_MOD_UATTR;
reorg table COMMUNITY.WP_SEARCH_REG;
reorg table COMMUNITY.WSRP_PROD;
reorg table COMMUNITY.WSRP_PROD_DD;
reorg table COMMUNITY.WSRP_PROD_LOD;
reorg table COMMUNITY.WSRP_PROD_UATTR;
reorg table SYSIBM.SYSATTRIBUTES;
reorg table SYSIBM.SYSBUFFERPOOLNODES;
reorg table SYSIBM.SYSBUFFERPOOLS;
reorg table SYSIBM.SYSCHECKS;
reorg table SYSIBM.SYSCODEPROPERTIES;
reorg table SYSIBM.SYSCOLAUTH;
reorg table SYSIBM.SYSCOLCHECKS;
reorg table SYSIBM.SYSCOLDIST;
reorg table SYSIBM.SYSCOLGROUPDIST;
reorg table SYSIBM.SYSCOLGROUPDISTCOUNTS;
reorg table SYSIBM.SYSCOLGROUPS;
reorg table SYSIBM.SYSCOLGROUPSCOLS;
reorg table SYSIBM.SYSCOLOPTIONS;
reorg table SYSIBM.SYSCOLPROPERTIES;
reorg table SYSIBM.SYSCOLUMNS;
reorg table SYSIBM.SYSCOLUSE;
reorg table SYSIBM.SYSCOMMENTS;
reorg table SYSIBM.SYSCONSTDEP;
reorg table SYSIBM.SYSDATATYPES;
reorg table SYSIBM.SYSDBAUTH;
reorg table SYSIBM.SYSDEPENDENCIES;
reorg table SYSIBM.SYSEVENTMONITORS;
reorg table SYSIBM.SYSEVENTS;
reorg table SYSIBM.SYSEVENTTABLES;
reorg table SYSIBM.SYSFUNCMAPOPTIONS;
reorg table SYSIBM.SYSFUNCMAPPARMOPTIONS;
reorg table SYSIBM.SYSFUNCMAPPINGS;
reorg table SYSIBM.SYSHIERARCHIES;
reorg table SYSIBM.SYSINDEXAUTH;
reorg table SYSIBM.SYSINDEXCOLUSE;
reorg table SYSIBM.SYSINDEXES;
reorg table SYSIBM.SYSINDEXEXPLOITRULES;
reorg table SYSIBM.SYSINDEXEXTENSIONMETHODS;
reorg table SYSIBM.SYSINDEXEXTENSIONPARMS;
reorg table SYSIBM.SYSINDEXEXTENSIONS;
reorg table SYSIBM.SYSINDEXOPTIONS;
reorg table SYSIBM.SYSJARCONTENTS;
reorg table SYSIBM.SYSJAROBJECTS;
reorg table SYSIBM.SYSKEYCOLUSE;
reorg table SYSIBM.SYSLIBRARIES;
reorg table SYSIBM.SYSLIBRARYAUTH;
reorg table SYSIBM.SYSLIBRARYBINDFILES;
reorg table SYSIBM.SYSLIBRARYVERSIONS;
reorg table SYSIBM.SYSNAMEMAPPINGS;
reorg table SYSIBM.SYSNODEGROUPDEF;
reorg table SYSIBM.SYSNODEGROUPS;
reorg table SYSIBM.SYSPARTITIONMAPS;
reorg table SYSIBM.SYSPASSTHRUAUTH;
reorg table SYSIBM.SYSPLAN;
reorg table SYSIBM.SYSPLANAUTH;
reorg table SYSIBM.SYSPLANDEP;
reorg table SYSIBM.SYSPREDICATESPECS;
reorg table SYSIBM.SYSPROCOPTIONS;
reorg table SYSIBM.SYSPROCPARMOPTIONS;
reorg table SYSIBM.SYSRELS;
reorg table SYSIBM.SYSROUTINEAUTH;
reorg table SYSIBM.SYSROUTINEPARMS;
reorg table SYSIBM.SYSROUTINEPROPERTIESJAVA;
reorg table SYSIBM.SYSROUTINES;
reorg table SYSIBM.SYSSCHEMAAUTH;
reorg table SYSIBM.SYSSCHEMATA;
reorg table SYSIBM.SYSSECTION;
reorg table SYSIBM.SYSSEQUENCEAUTH;
reorg table SYSIBM.SYSSEQUENCES;
reorg table SYSIBM.SYSSERVEROPTIONS;
reorg table SYSIBM.SYSSERVERS;
reorg table SYSIBM.SYSSTMT;
reorg table SYSIBM.SYSTABAUTH;
reorg table SYSIBM.SYSTABCONST;
reorg table SYSIBM.SYSTABLES;
reorg table SYSIBM.SYSTABLESPACES;
reorg table SYSIBM.SYSTABOPTIONS;
reorg table SYSIBM.SYSTBSPACEAUTH;
reorg table SYSIBM.SYSTRANSFORMS;
reorg table SYSIBM.SYSTRIGGERS;
reorg table SYSIBM.SYSTYPEMAPPINGS;
reorg table SYSIBM.SYSUSERAUTH;
reorg table SYSIBM.SYSUSEROPTIONS;
reorg table SYSIBM.SYSVERSIONS;
reorg table SYSIBM.SYSVIEWDEP;
reorg table SYSIBM.SYSVIEWS;
reorg table SYSIBM.SYSWRAPOPTIONS;
reorg table SYSIBM.SYSWRAPPERS;
reorg table SYSIBM.SYSXMLOBJECTAUTH;
reorg table SYSIBM.SYSXMLOBJECTAUTHPERF;
reorg table SYSIBM.SYSXMLOBJECTPROPERTIES;
reorg table SYSIBM.SYSXMLOBJECTRELDEP;
reorg table SYSIBM.SYSXMLOBJECTS;
reorg table SYSIBM.SYSXMLOBJECTXMLDEP;
reorg table SYSIBM.SYSXMLPHYSICALCOLLECTIONS;
reorg table SYSIBM.SYSXMLQUERIES;
reorg table SYSIBM.SYSXMLRELATIONSHIPS;
reorg table SYSIBM.SYSXMLRSPROPERTIES;
reorg table SYSIBM.SYSXMLSTATS;
reorg table SYSTOOLS.HMON_ATM_INFO;
reorg table SYSTOOLS.HMON_COLLECTION;
reorg table SYSTOOLS.POLICY;
reorg table SYSTOOLS.STMG_DBSIZE_INFO;

$ db2 -tvf reorg_test.db2

DB21007E End of file reached while reading the command.

If i am performing same steps for another DB its working...........

Did you create this file (reorg_test.db2) on the AIX box, or transferred it from a Windows workstation?

i don't have any idea about that, DBA before me has created tat file, wat i have 2 do now, i have to create againg in server?????

Yeah I would suggest that ... Create a new file with vi on the server und try to run it again.

Thnx for your reply , i will try it................ can we run this reorg activity like this(db2 -tvf reorg_test.db2) i.e. at a time for tables???? whether it is a correct procedure or not????
is there any order for reorg i.e first we have to reorg table, next primary index, next secondary index ......., is there any relationship between reorg and no. of free pages on tablespaces?????????????????????
pls anyone help me out,
Thnx in advance.....