DB2

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDatabasesDB2

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old November 10th, 2016, 01:12 PM
DMo2 DMo2 is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Nov 2016
Posts: 2 DMo2 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 31 m 20 sec
Reputation Power: 0
DB2 11.1 SQL1022C Not enough memory

I hope this is not a duplicate post. I did not have luck in returning search results.

I have windows 7 Professional that is running a vmware Windows 10 Professional. The host machine has 16G RAM, vm RAM 4G (also tried it with 12G), DB2 version 11.1. I am a web programmer and I am not fluent in DB2. I was tasked with setting up a windows 10 vm for developers. The DB2 database is remote on a z/OS 10.1.2 server.

db2licm -l returns the following

Product name: "DB2 Connect Enterprise Edition"
License type: "Client Device"
Expiry date: "Permanent"
Product identifier: "db2consv"
Version information: "11.1"

Although the error returned from the command prompt indicates a memory problem when I look in db2diag.log I can also see a ssl problem. Here is text from the log.


2016-11-07-14.28.42.141000-300 I3166F368 LEVEL: Error
PID : 6340 TID : 892 PROC : db2bp.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: DevMasterWin10
EDUID : 892
FUNCTION: DB2 UDB, common communication, sqlccGetSSLApiAddress, probe:395
MESSAGE : DIA3602E Error getting SSL function address: "pgsk_msgerror".

2016-11-07-14.28.42.208000-300 I3536F343 LEVEL: Error
PID : 6340 TID : 892 PROC : db2bp.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: DevMasterWin10
EDUID : 892
FUNCTION: DB2 UDB, common communication, sqlccLoadSSLLibrary, probe:309
RETCODE : ZRC=0x90000078=-1879048072


2016-11-07-14.28.42.410000-300 I3881F445 LEVEL: Error
PID : 6340 TID : 892 PROC : db2bp.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: DevMasterWin10
EDUID : 892
FUNCTION: DB2 UDB, common communication, sqlccLoadSSLLibrary, probe:309
RETCODE : ZRC=0x00000E12=3602
SQL3602W Check data processing found constraint violations and moved
them to exception tables.


2016-11-07-14.28.42.451000-300 I4328F361 LEVEL: Error
PID : 6340 TID : 892 PROC : db2bp.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: DevMasterWin10
EDUID : 892
FUNCTION: DB2 UDB, common communication, sqlccLoadSSLLibrary, probe:998
MESSAGE : DIA3603E SSL was not setup. Return code = "-1879048072".

2016-11-07-14.28.42.534000-300 I4691F491 LEVEL: Severe
PID : 6340 TID : 892 PROC : db2bp.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: DevMasterWin10
EDUID : 892
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcCommConnect, probe:10
MESSAGE : ZRC=0x80360053=-2143944621=SQLZ_RC_BDS_INSSYS, SQLT_SQLJC
"Insufficient system resources"
DATA #1 : String, 11 bytes
CCI Error:
DATA #2 : unsigned integer, 8 bytes
120


I am currently using the gsk 32 and 64 bit install files.

Here is what I have done.
The following steps worked for DB2 IBM Data Server Client 9.7 running on server 2008 R2 standard.

1. Logged into VM using the local Administrator account.
2. Installed IBM Data Server Client Version 11.1. Ran setup.exe with run as Administrator. I used the typical install options with one exception. I selected the option to not create a response file.
3. Applied the license file through the elevated DB2 command prompt.
4. Added an entry to the C:\Windows\System32\drivers\etc\services file to allow connection for the DB2 database.
5. Added the following local users to the DB2ADMNS account. IUSR, NETWORK SERVICE, SYSTEM and INTERACTIVE. Typically only the IUSR and NETWORK SERVICE is needed but since I was having problems I added the other two.
6. Installed gsk8ssl32.exe and gsk8crypt32.exe (version 8.0.14.14).
7. Added C:\Program Files\IBM\GSK8\lib64 and C:\Program Files (x86)\IBM\GSK8\lib to the path system environment variables.
8. Rebooted the vm.
9. At the elevated DB2 command prompt I created a key database a stash file. This was done from C:\Program Files (x86)\IBM\GSK8\bin\
10. Through windows explorer I add the local DB2ADMNS group to the stash file located at C:\Program Files (x86)\IBM\GSK8\lib. The permissions are read and read & execute.
11. Added a cert to the key database that is needed for the calls.
12. From the elevated DB2 command prompt I added updated the dbm cfg and applied the kdb file to SSL_CLNT_KEYDB as well as the sth file to the SSL_CLNT_STASH.
13. From the elevated DB2 command prompt I cataloged the tcpip node to sslnode remote and the security is SSL.
14. From the elevated DB2 command prompt I cataloged database with node as sslnode and authentication server.
15. Installed gsk8ssl64.exe and gsk8crypt64.exe (version 8.0.14.14).
16. Through Windows Explorer I ran the odbcad32.exe (as admin) file from the SysWOW64 folder. Then I add a system DSN for the 32 bit.
17. Through Windows Explorer I ran the odbcad32.exe (as admin) file from the System32 folder. Then I add a system DSN. I do get a warning that says "You are logged on with non-Administrative privileges. System DSNs could not be created or modified.". However, I am allowed to continue and add a system DSN for the 64 bit.
18. Through Windows Explorer I ran the odbcad32.exe (as admin) file from the SysWOW64 folder. I selected the 32 bit system DSN and added CLI parameters.
19. Through Windows Explorer I ran the odbcad32.exe (as admin) file from the System folder. I selected the 64 bit system DSN and added CLI parameters. They already existed from step 18 but I went through the steps anyway.
20. Now I go to an elevated DB2 command prompt and attempt to connect to the database. The message at the command prompt is SQL1022C There is not enough memory available to process the command. SQLSTATE=57011.

Please help.

Thanks.

Reply With Quote
  #2  
Old December 6th, 2016, 04:32 AM
Smith-K Smith-K is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Dec 2016
Location: Leeds, UK
Posts: 2 Smith-K User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 22 m 18 sec
Reputation Power: 0
I think restore command internally uses some blocking cursors with select statements and that's where the problem is popping up from. The communication buffer space should be large enough to hold the result set of the query.

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesDB2 > DB2 11.1 SQL1022C Not enough memory


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap