I am trying to create a stored procedure using the DB2 Connect
Development Center. I am able to create the project, connect to the
remote database on the mainframe and create the stored procedure.
However, when I build I get the following message:
[IBM][CLI Driver][DB2] SQL0567N "I01" is not a valid authorization
ID. SQLSTATE=42503
I01.ED_MAINLINE _PERSON - Build failed.
The options for the database connection are as follows:
SQL ID = I01
Package Owner = I01
Build Owner = I01
These are identical to what another programmer uses who can build
stored procedures. We've checked the ACF permissions on the mainframe
and I have the identical rights as the other programmers.
We are stumped and it clearly appears to be some sort of access
problem but we can't figure out what is missing.
One of the programmers had me try and set the current SQL ID in the
command editor and I was unable to. She thought this was significant
but we don't know how to address this.
Help!
Ann Williams
3  4205 
Hi,
This is a RACF problem. The fact that you cannot issue the command SET
CURRENT SQLID='IO1' means that you do not belong to the RACF group of IO1 -
In the mainframe, do a TSO LU command and it will list out all your groups
that you are allowed to. Ask your RACF administrator to display all the
userids of those who belong to the 'IO1' group.
The other facet is that if you are accessing the mainframe via the JDBC/ODBC
driver, there is an implied userid associated with this and it is quite
possible that this implied userid does not belong to the RACF group of
'IO1'. Did you connect passing a specific userid with password and does this
userid have the privileges associated with creating a procedure, for example
GRANT CREATEIN TO SCHEMA XX blah blah....
HTH,
Ven Ilagan
Sydney
"annoir" <an****@gmail.c omwrote in message
news:11******** *************@l 77g2000hsb.goog legroups.com...
>I am trying to create a stored procedure using the DB2 Connect
Development Center. I am able to create the project, connect to the
remote database on the mainframe and create the stored procedure.
However, when I build I get the following message:
[IBM][CLI Driver][DB2] SQL0567N "I01" is not a valid authorization
ID. SQLSTATE=42503
I01.ED_MAINLINE _PERSON - Build failed.
The options for the database connection are as follows:
SQL ID = I01
Package Owner = I01
Build Owner = I01
These are identical to what another programmer uses who can build
stored procedures. We've checked the ACF permissions on the mainframe
and I have the identical rights as the other programmers.
We are stumped and it clearly appears to be some sort of access
problem but we can't figure out what is missing.
One of the programmers had me try and set the current SQL ID in the
command editor and I was unable to. She thought this was significant
but we don't know how to address this.
Help!
Ann Williams
On Apr 20, 2:29 am, "Ven Ilagan" <vcila...@optus net.com.auwrote :
Hi,
This is a RACF problem. The fact that you cannot issue the command SET
CURRENT SQLID='IO1' means that you do not belong to the RACF group of IO1 -
In the mainframe, do a TSO LU command and it will list out all your groups
that you are allowed to. Ask your RACF administrator to display all the
userids of those who belong to the 'IO1' group.
The other facet is that if you are accessing the mainframe via the JDBC/ODBC
driver, there is an implied userid associated with this and it is quite
possible that this implied userid does not belong to the RACF group of
'IO1'. Did you connect passing a specific userid with password and does this
userid have the privileges associated with creating a procedure, for example
GRANT CREATEIN TO SCHEMA XX blah blah....
HTH,
Ven Ilagan
Sydney"annoir" <ann...@gmail.c omwrote in message
news:11******** *************@l 77g2000hsb.goog legroups.com...
I am trying to create a stored procedure using the DB2 Connect
Development Center. I am able to create the project, connect to the
remote database on the mainframe and create the stored procedure.
However, when I build I get the following message:
[IBM][CLI Driver][DB2] SQL0567N "I01" is not a valid authorization
ID. SQLSTATE=42503
I01.ED_MAINLINE _PERSON - Build failed.
The options for the database connection are as follows:
SQL ID = I01
Package Owner = I01
Build Owner = I01
These are identical to what another programmer uses who can build
stored procedures. We've checked the ACF permissions on the mainframe
and I have the identical rights as the other programmers.
We are stumped and it clearly appears to be some sort of access
problem but we can't figure out what is missing.
One of the programmers had me try and set the current SQL ID in the
command editor and I was unable to. She thought this was significant
but we don't know how to address this.
Help!
Ann Williams- Hide quoted text -
- Show quoted text -
Thanks! I will pass this information along to our administrator.
Annie
On Apr 19, 11:48 am, annoir <ann...@gmail.c omwrote:
I am trying to create a stored procedure using the DB2 Connect
Development Center. I am able to create the project, connect to the
remote database on the mainframe and create the stored procedure.
However, when I build I get the following message:
[IBM][CLI Driver][DB2] SQL0567N "I01" is not a valid authorization
ID. SQLSTATE=42503
I01.ED_MAINLINE _PERSON - Build failed.
The options for the database connection are as follows:
SQL ID = I01
Package Owner = I01
Build Owner = I01
These are identical to what another programmer uses who can build
stored procedures. We've checked the ACF permissions on the mainframe
and I have the identical rights as the other programmers.
We are stumped and it clearly appears to be some sort of access
problem but we can't figure out what is missing.
One of the programmers had me try and set the current SQL ID in the
command editor and I was unable to. She thought this was significant
but we don't know how to address this.
Help!
Ann Williams
Hi Ann,
In addition to what Ven said, you need to talk to your administrator
about setting up the Work
Load Manager environment. There is a good chapter in the redbook:
"DB2 for z/OS Stored Procedures,
Through the Call and Beyond", http://publib-b.boulder.ibm.com/abst...7083.html?Open.
that deals with setting up your mainframe for access by DB2
Development Center.
Marichu Scanlon
IBM This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ash |
last post by:
Hi all,
I have a C# web application which calls a number of stored procedures.
I wish to step into the stored procedures while debugging i.e "Mix-mode
debugging":
I have completed the following steps:
Configured DCOM
Connected to database via Server Manager (I can see the SQL server and the
stored procedure)
|
by: hubert_s |
last post by:
I have DB2 8.1 FP7, when I try to build a Java stored procedure it fails
during a call to DB2_REPLACE_JAR. Even the build folder "bld1096553970703"
is not there - it has a different name,
regards,
Hubert
DB2ADMIN.PROCEDURE2 - Build started.
DROP SPECIFIC PROCEDURE DB2ADMIN.SQL030805133228210
DB2ADMIN.PROCEDURE2 - Drop stored procedure completed.
|
by: dharmadam |
last post by:
I am trying to build a simple SQL stored procedure in DB2 Stored
Procedure Builder V7.
It gives me the following message. Can someone help me to identify the
problem.
QCPI039.CREATE_DAILY_BENEF_XREF_DN - Create stored procedure returns
-7032.
QCPI039.CREATE_DAILY_BENEF_XREF_DN:
|
by: Ash |
last post by:
Hi all,
I have a C# web application which calls a number of stored procedures.
I wish to step into the stored procedures while debugging i.e "Mix-mode
debugging":
I have completed the following steps:
Configured DCOM
Connected to database via Server Manager (I can see the SQL server and the
stored procedure)
|
by: Ash |
last post by:
Hi all,
I have a C# web application which calls a number of stored procedures.
I wish to step into the stored procedures while debugging i.e "Mix-mode
debugging":
I have completed the following steps:
Configured DCOM
Connected to database via Server Manager (I can see the SQL server and the
stored procedure)
| | |
by: Michael |
last post by:
Running DB2 v7 UDB ("DB2 v7.1.0.93", "n031208" and "WR21333") on Windows XP,
I am unable to find out why the "Build for Debug" option within Stored
Procedure Builder is not enabled on Java stored procedures. It is enabled
for SQL stored procedures.
It is possible to "Build" and "Run" the Java SPs, it just isn't possible to
click on the "Build for Debug" option. Thanks for any help in advance.
Michael
|
by: serge |
last post by:
/*
Subject: How to build a procedure that returns different
numbers of columns as a result based on a parameter.
You can copy/paste this whole post in SQL Query Analyzer
or Management Studio and run it once you've made sure
there is no harmful code.
Currently we have several stored procedures which final
result is a select with several joins that returns many
|
by: sheenaa |
last post by:
Hello Members,
I m creating my application forms in ASP.Net 2005 C# using the backend SQL Server 2005.
What i have used on forms :: ?
On my first form i have used some label,textboxs,dropdownlists,radiobutton and checkbox asp standard controls.
On the click event of the command button the data gets stored into the database.
I have created the stored procedures for the insert,update,delete.
I have...
|
by: DR |
last post by:
Unable to start TSQL Debugging. Could not attach to SQL Server Process on
'srvname'. The RPC server is unavailable.
I get this error when I try to run a SQL Server Project with a CLR stored
Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I
simply create a new SQL Server Project which creates a Test.sql, i then
simply added a Stored Procedure to it called the default name
StoredProcedure1.cs and put a break point...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
