Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RTC 3.01 createTables fail on z/OS DB2

Questions
Tags
Users
Badges
Jorge Nagasaki
(175●1●22●17) Jul 12 '11, 9:57 a.m.
I am trying to create JTS DB2 tables on z/OS after configuring the teamserver.properties following the infocenter documentation and it is failing with the following messages:

Repo Tools
Provisioning using "/rtc301/etc/jazz/jts/provision_profiles".
Jazz Foundation - Core Libraries, Version 3.0.1 (RJF-I20110602-0017)
CRJAZ1363I Loading the configuration from "file:/rtc301/etc/jazz/jts/teamserver.properties".
CRJAZ1779I This server is configured as a JTS.
CRJAZ1781W The Public URI Root has not been set. Use the server setup wizard to enter the public URI. This property is required to
enforce consistent URL management in the application. The public URI represents the URL that all clients must use to access the ap
plication.
CRJAZ1365I The server is attempting to connect to the following database: "//10.1.1.2:5025/DALLAS9:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2
Db Product Version: DSN09015
Db URL: jdbc:db2://10.1.1.2:5025/DALLAS9:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.58.104
CRJAZ1093I The following service class was not activated: "com.ibm.team.repository.service.internal.schemagen.PersistentMappingServi
ce"
CRJAZ1141I Cannot get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService".
CRJAZ1203I Could not determine the database location.
CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService" is not available.
Creating the tables for the database "//10.1.1.2:5025/DALLAS9:user=xxxxxxxx;password=xxxxxxxx;" with indices.
CRJAZ1141I Cannot get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseCreationService".
CRJAZ1309I The database connectivity service is not ready.
The database tables were not created.

I could not figure out what is wrong, please can you help?

0 votes

6 answers
7,328 views
0 votes

6 answers

Permanent link
Bruce Green
JAZZ DEVELOPER (301●2●4) Jul 12 '11, 11:38 a.m.
Hello Jorge -

The BLZCREDB sample job has a line like (replaced with your edits of course) :

logFile=@workPath@/logs/create@appl@.log

which should point to a more detailed log file. Note that the log file is in ASCII so you need to edit accordingly (for example ASCII EDIT from ISPF 3.17, Rational Developer for System z, or ftp in binary to an ASCII based machine.)

The root exception in that log should help determine the problem. If you still have trouble, please gather (a) JCL source for BLZCREDB (b) JCL output for BLZCREDB (c) teamserver.properties and (d) the log I mentioned. And either send to me or open a work item and use Filed Against of Enterprise Extensions.

Thanks
Bruce

0 votes

Permanent link
Jorge Nagasaki
(175●1●22●17) Jul 12 '11, 3:11 p.m.
Hi Bruce,
I got the docs will send you by e-mail..
I was looking into this again and I think I have a problem with WLM setup. I read the infocenter again and there is a procedure to check the WLM setup for DB2 , and I found that I do not have this setup done ( I am using the z/OS on RDzUT ) . May be this is the cause of the problem?
I need to find someone that can help me setup this environment, and get back with the results, hope to find someone here.

0 votes

Permanent link
Bruce Green
JAZZ DEVELOPER (301●2●4) Jul 12 '11, 4:21 p.m.
Hi Jorge - yes, in the logs you sent, you can see :

com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-471, SQLSTATE=55023, SQLERRMC=SYSIBM.SQLTABLES;00E7900C, DRIVER=3.58.104

If you look at : http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp

You can see that this part of the error code: 00E7900C

Explanation
SQL CALL statement or user-defined function invocation could not be processed. The WLM application environment name specified for the user-written routine is not defined or is currently not available for DB2 use in the active WLM policy.

WLM set up is required.

0 votes

Permanent link
Jorge Nagasaki
(175●1●22●17) Jul 14 '11, 11:37 p.m.
Ok. I configured WLM and now I was able to createTables successfully.
Now I am having a new issue when starting the Tomcat on z/OS , ad this is a new problem I am posting a new thread..
Thank you

0 votes

Permanent link
Jorge Nagasaki
(175●1●22●17) Jul 14 '11, 11:45 p.m.
After configuring the RTC 301 succssfully, I tried to start TOMCAT with BLZSRVD and I am getting the following error:
Jul 14, 2011 9:57:15 PM org.apache.catalina.session.ManagerBase setRandomFile
WARNING: Error reading /dev/urandom
Throwable occurred: java.io.FileNotFoundException: /dev/urandom (EDC5157I An int
at java.io.FileInputStream.<init>(FileInputStream.java:112)
at org.apache.catalina.session.ManagerBase.setRandomFile(ManagerBase.java:528)
at org.apache.catalina.session.ManagerBase.getRandomBytes(ManagerBase.java:964)
at org.apache.catalina.session.ManagerBase.init(ManagerBase.java:752)
at org.apache.catalina.session.StandardManager.start(StandardManager.java:619)
at org.apache.catalina.core.ContainerBase.setManager(ContainerBase.java:432)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4196)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:7
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:980)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:943
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1203)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:319)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
at java.lang.reflect.Method.invoke(Method.java:600)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Jul 14, 2011 9:57:16 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-19080

I checked in OMVS that I have the /dev/urandom OK when I do ls -la /dev/urandom

Is this error expected, or do I still have some problem?

0 votes

Permanent link
Bruce Green
JAZZ DEVELOPER (301●2●4) Jul 15 '11, 8:43 a.m.
Jorge -

This error can be safely ignored - see also https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/147312

Thanks ... Bruce

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jul 12 '11, 9:57 a.m.

Question was seen: 7,328 times

Last updated: Jul 12 '11, 9:57 a.m.

Confirmation Cancel Confirm