it is not recommended to use userexit anymore
db2level/platform ?
logarchmeth1/2 can be used
best regards, Guy Przytula
przytula
Last Activity: Jun 18 '14, 09:45 AM
Joined: Jun 14 '09
Location: Kermt,Belgium
-
przytula replied to DB2 "No Storage Available for allocation" DIA8305C Memory allocation failure occurredin DB2and what seems to be the problem ?
best regards, Guy PrzytulaLeave a comment:
-
is the restore on same machine ?
have you tried a re-directed restore ?
best regards, Guy PrzytulaLeave a comment:
-
I would never do this in crontab like indicated
create a single script with
/path/db2profile --> the complete path
execute script with options
you avoid working in sub-shell and loosing connection....
Best Regards, Guy PrzytulaLeave a comment:
-
how about the info center at
http://publib.boulder.ibm.com/infoce.../cjvjdcon.html
best regards, guy...Leave a comment:
-
try to execute this locally and ftp the result file
best regards, guy przytulaLeave a comment:
-
run db2look to extract ddl
try export local - connect iseries and import/load
best regards, guy przytulaLeave a comment:
-
there are many differences this can not be explained over here....
most sql is the same (see cookbook for sql)
the admin is totally different
best regards, guy przytulaLeave a comment:
-
do you have db2 connect installed ? have you tried a simple connect and select to as/400 ?
also something with codepage : try chcp to see the codepage
and the codepage of as/400 db2
best regards, guy przytulaLeave a comment:
-
the order can be any order, if not specified
do explain and see, which table is accessed first
best regards, guy przytulaLeave a comment:
-
there are always header pages, and pages used to keep the chain between pages..
best regards, guy przytulaLeave a comment:
-
it is trying todo an implicit bind of db2 bind files
you don't have bind authority
in another system the bind might have been done by an administrator..
best regards, guy przytulaLeave a comment:
-
after 'WNONEN','' why this ''
if using 'WNONE',, I think this should work...
best regards, guy przytulaLeave a comment:
No activity results to display
Leave a comment: