RE: Some Inbuild Proc and function are missing

RE: Some Inbuild Proc and function are missing

 

  

I have tried both the solution still same problem

I am not able run

db2 "select * from table(snapshot_dbm(-1)) as snapshot_dbm"
db2 "select * from table (snapshot_database('coatsaix',-1)) as
snapshot_database"

Plz. help me



(Embedded image moved
with regards, to file:
pic03450.jpg)
Jagdish S. Rawat
IBM Certified DB2 DBA
IBM Certified DB2 App. Developer
IBM, DLF Infinity Tower A, 4th Floor,
DLF Phase-II, NH-8,
Gurgoan -122002
Ph.# +91-124-4347152(Direct) +91-124-4347000 Ext. #
47152
Fax# +91-124-2566701
Mob# +919818433596
(Embedded image moved to file: pic11733.jpg)








"DANIEL CALLAHAN
"
<db2udbdba-ezmlms To
hield-x57512839.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

09/01/2006 05:33 Subject
PM RE: Some Inbuild Proc and function
are missing










Try running DB2UPDV8






"Singh Rahul "
<db2udbdba-ezmlms
hield-x84068976.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]

cc
09/01/2006 03:55
AM Subject
RE: Some Inbuild Proc and function
are missing










Just a thought..
Try binding all the system level packages again..

Rahul Singh

-----Original Message-----
From: Jagdish S Rawat [mailto:db2udbdba-ezmlmshield-x28426413.[Email
address protected]
Sent: Friday, September 01, 2006 1:05 PM
To: LazyDBA Discussion
Subject: Some Inbuild Proc and function are missing

Hi All,

I have a database in which some of the inbuild proc and function are
missing.

How can i create the lost one or is there any script by which i can create
all the proc and function again.
without exporting the function/proc from other database.


with regards,

Jagdish S. Rawat
IBM Certified DB2 DBA
IGSI, DLF Infinity Tower A, 4th Floor,
DLF Phase-II, NH-8,
Gurgoan -122001
Ph.# +91-124-4347152(Direct) +91-124-4347000 Ext. # 47152
Fax# +91-124-2566701
Mob# +919818433596
(Embedded image moved to file: pic11282.jpg)


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page