DB2 STORED NPROCEDURES   

Hello. I am trying to learn a bit about DB2 EXPRESS-C(I've got the latest version downloaded 2 weeks ago). So far I have managed to create the SAMPLE database that comes as part of the First Steps. Now using control centre I would like to get the size of the database. What i would like to achieve is calling a command(hopefully SQL Stored procedure) that would return the information in a data table. Eventually i would like to call this stored procedure from a simple .NET application and get all the relevant space information in a data table.

First off i'm keen to get the amount of database space using a very simple .NET functions. Not using Control Centre.
GET_DBSIZE_INFO, when executed successfully updates a table SYSTOOLS.STMG_DBSIZE_INFO with the appropriate space information. In my opinion to get what i need using my ..NET application I require 2 steps

Step 1: Execute GET_DBSIZE_INFO using a function written in .NET
Step 2: Read the SYSTOOLS.STMG_DBSIZE_INFO table for updated information using a function written in .NET

Now as relates Step 1 the function i've written is shown below, It basically calls the GET_DBSIZE_INFO stored procedure on a DB2 DATABASE CONNECTION

Public Function ExecDBSizeInfo() As Integer Implements DBInfoInterface.IGetDBSpaceInfo.ExecDBSizeInfo
Try
Dim Conn As New DB2Connection
Dim val As Integer

Dim param As New DB2Parameter("Input0", DB2Type.Char)
param.Value = "?"
Dim param1 As New DB2Parameter("Input1", DB2Type.Char)
param1.Value = "?"
Dim param2 As New DB2Parameter("Input2", DB2Type.Char)
param2.Value = "?"
Dim param3 As New DB2Parameter("Input3", DB2Type.Integer)
param3.Value = "0"

Dim db2Params As DB2Parameter() = {param, param1, param2, param3}

Conn.ConnectionString = DB2Helper.DB2Helper.ConnString
val = DB2Helper.DB2Helper.ExecuteNonQuery(Conn, "SYSPROC.GET_DBSIZE_INFO", db2Params)
Conn.Close()
Conn.Dispose()
ExecDBSizeInfo = val
Return ExecDBSizeInfo

Catch ex As DB2Exception
Throw ex
End Try

End Function

If the function executes successfully I should get 0 (zero) as the result of the funtion. Currently i get
-1(negative one),meaning the SYSPROC.GET_DBSIZE_INFO is not executing successfully.

Can anyone help me understand what is going wrong?

No joy so far

I've tried everything

Public Function ExecDBSizeInfo() As Integer Implements DBInfoInterface.IGetDBSpaceInfo.ExecDBSizeInfo
Try
Dim Conn As New DB2Connection
Dim val As Integer

Dim param As New DB2Parameter("Input0", DB2Type.Timestamp)
param.Value = "?"
Dim param1 As New DB2Parameter("Input1", DB2Type.BigInt)
param1.Value = "?"
Dim param2 As New DB2Parameter("Input2", DB2Type.BigInt)
param2.Value = "?"
Dim param3 As New DB2Parameter("Input3", DB2Type.Integer)
param3.Value = "0"

Dim db2Params As DB2Parameter() = {param, param1, param2, param3}

Conn.ConnectionString = DB2Helper.DB2Helper.ConnString
val = DB2Helper.DB2Helper.ExecuteNonQuery(Conn, "SYSPROC.GET_DBSIZE_INFO", db2Params)
Conn.Close()
Conn.Dispose()
ExecDBSizeInfo = val
Return ExecDBSizeInfo

Catch ex As DB2Exception
Throw ex
End Try

End Function

This did not work the function returns -1...so i tried

Public Function ExecDBSizeInfo() As Integer Implements DBInfoInterface.IGetDBSpaceInfo.ExecDBSizeInfo
Try
Dim Conn As New DB2Connection
Dim val As Integer

Dim param As New DB2Parameter("Input0", DB2Type.Timestamp)
param.Value = "?"
param.direction=parameterdirection.output
Dim param1 As New DB2Parameter("Input1", DB2Type.BigInt)
param1.Value = "?"
param.direction=parameterdirection.output
Dim param2 As New DB2Parameter("Input2", DB2Type.BigInt)
param2.Value = "?"
param.direction=parameterdirection.output
Dim param3 As New DB2Parameter("Input3", DB2Type.Integer)
param3.Value = "0"
param.direction=parameterdirection.Input

Dim db2Params As DB2Parameter() = {param, param1, param2, param3}

Conn.ConnectionString = DB2Helper.DB2Helper.ConnString
val = DB2Helper.DB2Helper.ExecuteNonQuery(Conn, "SYSPROC.GET_DBSIZE_INFO", db2Params)
Conn.Close()
Conn.Dispose()
ExecDBSizeInfo = val
Return ExecDBSizeInfo

Catch ex As DB2Exception
Throw ex
End Try

End Function

Still NO SUCCESS, Function returns -1, I even tried removing the param.value bits, and still no success. Slowly tearing my hair out. Looked at the spClient.VB and i'm reasonably sure they are doing much the same as me, yet i can't figure out why mine doesn't work. If anyone has any .NET experience using stored procedures especially system stored procedures I'd like to know what i'm doing wrong

Can anyone help me understand what is going wrong?

If the function executes successfully I should get 0 (zero) as the result of the funtion. Currently i get
-1(negative one),meaning the SYSPROC.GET_DBSIZE_INFO is not executing successfully.

Can anyone help me understand what is going wrong?