Data disappears when zoomed in ArcCatalog

We are trying to load spatial point data from a DB2 table using spatial
extender.  We can load the data fine and see the data set when zoomed at full
extent.  The problems we are having is when zoomed in the data disappears and
when we try to identify the point no information from the table appears.  We are
using DB2 8 with ArcGIS 9.1.


CREATE TABLE "WASTE"."MODNR_FACILTY"
 ("OBJECTID"  INTEGER          NOT NULL  GENERATED ALWAYS
    AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20, MINVALUE 1, MAXVALUE
2147483647, NO CYCLE, NO ORDER),
  "PK"        INTEGER,
  "NAME"      VARCHAR(150),
  "PRGMCD"    VARCHAR(80),
  "PGRMPK"    VARCHAR(50),
  "UTMEASTING"DECIMAL(9, 3),
  "UTMNORTHNG"DECIMAL(10, 3),
  "HCOLLCODE" VARCHAR(100),
  "TYPECODE"  VARCHAR(50),
  "ISFAC"     VARCHAR(1),
  "COORD_ID"  VARCHAR(50),
  "SHAPE"     DB2GSE.ST_POINT            INLINE LENGTH 659
 );
 
 
-- REGISTER THE FEATURE
-- Note: Make sure the -R coresponds to the real value (from DDL)
-- sdelayer -o register -l MODNR_FACILTY,shape -i 5152 -s n-nr1test -D nrdsdet3
-u waste -p ***** -R 1009 -e p -C objectid,USER

-- SET THE FEATURE EXTENT
-- sdelayer -o alter -l MODNR_FACILTY,shape -i 5152 -s n-nr1test -D nrdsdet3 -u
waste -p ******  -G 26915 -E calc -g 1000,3000,9000

/*

  NIGHTLY TASKS
  
*/


-- CLEAR ALL DATA FROM THE FEATURE
DELETE FROM MODNR_FACILTY;

-- INSERT ALL RECORDS FROM THE 
INSERT INTO MODNR_FACILTY 
   (PK,NAME,PRGMCD,PGRMPK, UTMEASTING,UTMNORTHNG,
   HCOLLCODE,TYPECODE,ISFAC,COORD_ID, SHAPE)
  
SELECT PK,NAME,PRGMCD,PGRMPK, UTMEASTING,UTMNORTHNG,
   HCOLLCODE,TYPECODE,ISFAC,COORD_ID,
db2gse.ST_Point(UTMEASTING,UTMNORTHNG,1009)
   FROM FAC_UTM_FP;
   

Using sdelayer -o alter to set the extents should be after populating 
the table by doing the insert.  Did you do it in that order?

It might be worthwhile to examine the contents of the SDE.LAYERS table 
to see if the minx, miny, maxx, maxy values look appropriate for your data.

renee.robinson@dnr.mo.gov wrote:
> We are trying to load spatial point data from a DB2 table using spatial
extender.  We can load the data fine and see the data set when zoomed at full
extent.  The problems we are having is when zoomed in the data disappears and
when we try to identify the point no information from the table appears.  We are
using DB2 8 with ArcGIS 9.1.
> 
> 
> CREATE TABLE "WASTE"."MODNR_FACILTY"
>  ("OBJECTID"  INTEGER          NOT NULL  GENERATED ALWAYS
>     AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20, MINVALUE 1,
MAXVALUE 2147483647, NO CYCLE, NO ORDER),
>   "PK"        INTEGER,
>   "NAME"      VARCHAR(150),
>   "PRGMCD"    VARCHAR(80),
>   "PGRMPK"    VARCHAR(50),
>   "UTMEASTING"DECIMAL(9, 3),
>   "UTMNORTHNG"DECIMAL(10, 3),
>   "HCOLLCODE" VARCHAR(100),
>   "TYPECODE"  VARCHAR(50),
>   "ISFAC"     VARCHAR(1),
>   "COORD_ID"  VARCHAR(50),
>   "SHAPE"     DB2GSE.ST_POINT            INLINE LENGTH 659
>  );
>  
>  
> -- REGISTER THE FEATURE
> -- Note: Make sure the -R coresponds to the real value (from DDL)
> -- sdelayer -o register -l MODNR_FACILTY,shape -i 5152 -s n-nr1test -D
nrdsdet3 -u waste -p ***** -R 1009 -e p -C objectid,USER
> 
> -- SET THE FEATURE EXTENT
> -- sdelayer -o alter -l MODNR_FACILTY,shape -i 5152 -s n-nr1test -D
nrdsdet3 -u waste -p ******  -G 26915 -E calc -g 1000,3000,9000
> 
> /*
> 
>   NIGHTLY TASKS
>   
> */
> 
> 
> -- CLEAR ALL DATA FROM THE FEATURE
> DELETE FROM MODNR_FACILTY;
> 
> -- INSERT ALL RECORDS FROM THE 
> INSERT INTO MODNR_FACILTY 
>    (PK,NAME,PRGMCD,PGRMPK, UTMEASTING,UTMNORTHNG,
>    HCOLLCODE,TYPECODE,ISFAC,COORD_ID, SHAPE)
>   
> SELECT PK,NAME,PRGMCD,PGRMPK, UTMEASTING,UTMNORTHNG,
>    HCOLLCODE,TYPECODE,ISFAC,COORD_ID,
db2gse.ST_Point(UTMEASTING,UTMNORTHNG,1009)
>    FROM FAC_UTM_FP;
>    

I have attached the xml.  Please let me know if you are able to load the data
and zoom in.

Thanks

I don't see anything attached.

renee.robinson@dnr.mo.gov wrote:
> I have attached the xml.  Please let me know if you are able to load the
data and zoom in.
> 
> Thanks