Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: DB21007E End ofthe File reached

    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..........................

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Each Statement needs a ";" at the end.

  3. #3
    Join Date
    Dec 2010
    Posts
    123
    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...........

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did you create this file (reorg_test.db2) on the AIX box, or transferred it from a Windows workstation?

  5. #5
    Join Date
    Dec 2010
    Posts
    123
    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?????

  6. #6
    Join Date
    Jan 2010
    Posts
    206
    Yeah I would suggest that ... Create a new file with vi on the server und try to run it again.

  7. #7
    Join Date
    Dec 2010
    Posts
    123
    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.....
    Last edited by ravichandrapratap; 02-01-11 at 07:06.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •