Hi,
I am getting the error while trying to take a backup of the schema
according to the backupschema.sq l written at http://www-128.ibm.com/developerwork...rticle/dm-0602...
db2 =CALL ADMIN.BACKUPSCH EMA('PKMSQA','/u01/Backup_schema')
SQL0438N Application raised error with diagnostic text: "EXPORT
raised
error". SQLSTATE=78000
db2 =>
Here PKMSQA is the schema name and '/u01/Backup_schema' is the
directory on AIX.
I am on DB2 9.1 with Aix 5.3.
Can anybody explain why this error is coming?
Please help as this is urgent.
Rahul
P.S. My previous message heading incorrectly stated that i was caaling
ADMIN.COPYSCHEM A, but i was calling ADMIN.BACKUPSCH EMA.
Apologies for the same. 5 3888
Rahul Babbar wrote:
Hi,
I am getting the error while trying to take a backup of the schema
according to the backupschema.sq l written at http://www-128.ibm.com/developerwork...rticle/dm-0602...
db2 =CALL ADMIN.BACKUPSCH EMA('PKMSQA','/u01/Backup_schema')
SQL0438N Application raised error with diagnostic text: "EXPORT
raised
error". SQLSTATE=78000
db2 =>
Here PKMSQA is the schema name and '/u01/Backup_schema' is the
directory on AIX.
I am on DB2 9.1 with Aix 5.3.
Can anybody explain why this error is coming?
Please help as this is urgent.
Rahul
P.S. My previous message heading incorrectly stated that i was caaling
ADMIN.COPYSCHEM A, but i was calling ADMIN.BACKUPSCH EMA.
Apologies for the same.
These are from my developerWorks article?
In 99% of the cases the reason is in permissions.
IMPORT is using the fenced ID (which often is the same as the instance
id). That id needs to have access to the directory.
I do have an improved version of the DDLs. If you ping me I can send it
to you.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
On Sep 19, 6:50 pm, Serge Rielau <srie...@ca.ibm .comwrote:
Rahul Babbar wrote:
Hi,
I am getting the error while trying to take a backup of the schema
according to the backupschema.sq l written at http://www-128.ibm.com/developerwork...rticle/dm-0602...
db2 =CALL ADMIN.BACKUPSCH EMA('PKMSQA','/u01/Backup_schema')
SQL0438N Application raised error with diagnostic text: "EXPORT
raised
error". SQLSTATE=78000
db2 =>
Here PKMSQA is the schema name and '/u01/Backup_schema' is the
directory on AIX.
I am on DB2 9.1 with Aix 5.3.
Can anybody explain why this error is coming?
Please help as this is urgent.
Rahul
P.S. My previous message heading incorrectly stated that i was caaling
ADMIN.COPYSCHEM A, but i was calling ADMIN.BACKUPSCH EMA.
Apologies for the same.
These are from my developerWorks article?
In 99% of the cases the reason is in permissions.
IMPORT is using the fenced ID (which often is the same as the instance
id). That id needs to have access to the directory.
I do have an improved version of the DDLs. If you ping me I can send it
to you.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Serge,
Can you please send the improved version to me. as soon as possible?
Thanks
Rahul
Rahul Babbar wrote:
On Sep 19, 6:50 pm, Serge Rielau <srie...@ca.ibm .comwrote:
>Rahul Babbar wrote:
>>Hi, I am getting the error while trying to take a backup of the schema according to the backupschema.sq l written at http://www-128.ibm.com/developerwork...rticle/dm-0602... db2 =CALL ADMIN.BACKUPSCH EMA('PKMSQA','/u01/Backup_schema') SQL0438N Application raised error with diagnostic text: "EXPORT raised error". SQLSTATE=78000 db2 => Here PKMSQA is the schema name and '/u01/Backup_schema' is the directory on AIX. I am on DB2 9.1 with Aix 5.3. Can anybody explain why this error is coming? Please help as this is urgent. Rahul P.S. My previous message heading incorrectly stated that i was caaling ADMIN.COPYSCH EMA, but i was calling ADMIN.BACKUPSCH EMA. Apologies for the same.
These are from my developerWorks article? In 99% of the cases the reason is in permissions. IMPORT is using the fenced ID (which often is the same as the instance id). That id needs to have access to the directory. I do have an improved version of the DDLs. If you ping me I can send it to you.
Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab
Serge,
Can you please send the improved version to me. as soon as possible?
done
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
On Sep 20, 5:08 pm, Serge Rielau <srie...@ca.ibm .comwrote:
Rahul Babbar wrote:
On Sep 19, 6:50 pm, Serge Rielau <srie...@ca.ibm .comwrote:
Rahul Babbar wrote: Hi, I am getting the error while trying to take a backup of the schema according to the backupschema.sq l written at http://www-128.ibm.com/developerwork...rticle/dm-0602... db2 =CALL ADMIN.BACKUPSCH EMA('PKMSQA','/u01/Backup_schema') SQL0438N Application raised error with diagnostic text: "EXPORT raised error". SQLSTATE=78000 db2 => Here PKMSQA is the schema name and '/u01/Backup_schema' is the directory on AIX. I am on DB2 9.1 with Aix 5.3. Can anybody explain why this error is coming? Please help as this is urgent. Rahul P.S. My previous message heading incorrectly stated that i was caaling ADMIN.COPYSCHE MA, but i was calling ADMIN.BACKUPSCH EMA. Apologies for the same.
These are from my developerWorks article?
In 99% of the cases the reason is in permissions.
IMPORT is using the fenced ID (which often is the same as the instance
id). That id needs to have access to the directory.
I do have an improved version of the DDLs. If you ping me I can send it
to you.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Serge,
Can you please send the improved version to me. as soon as possible?
done
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Serge,
I am again getting the same error
db2 = call ADMIN.BACKUPSCH EMA('PKMSQA2', '/u01/Backup_schema')
SQL0438N Application raised error with diagnostic text: "EXPORT
raised
error". SQLSTATE=78000
db2 =>
I have checked that everybody has been given read/write/execute
permissions for the directory (/u01/Backup_schema).
What else could be the error?
Rahul
Rahul Babbar wrote:
On Sep 20, 5:08 pm, Serge Rielau <srie...@ca.ibm .comwrote:
>Rahul Babbar wrote:
>>On Sep 19, 6:50 pm, Serge Rielau <srie...@ca.ibm .comwrote: Rahul Babbar wrote: Hi, I am getting the error while trying to take a backup of the schema according to the backupschema.sq l written at http://www-128.ibm.com/developerwork...rticle/dm-0602... db2 =CALL ADMIN.BACKUPSCH EMA('PKMSQA','/u01/Backup_schema') SQL0438N Application raised error with diagnostic text: "EXPORT raised error". SQLSTATE=78000 db2 => Here PKMSQA is the schema name and '/u01/Backup_schema' is the directory on AIX. I am on DB2 9.1 with Aix 5.3. Can anybody explain why this error is coming? Please help as this is urgent. Rahul P.S. My previous message heading incorrectly stated that i was caaling ADMIN.COPYS CHEMA, but i was calling ADMIN.BACKUPSCH EMA. Apologies for the same. These are from my developerWorks article? In 99% of the cases the reason is in permissions. IMPORT is using the fenced ID (which often is the same as the instance id). That id needs to have access to the directory. I do have an improved version of the DDLs. If you ping me I can send it to you. Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab Serge, Can you please send the improved version to me. as soon as possible?
done
-- Serge Rielau DB2 Solutions Development IBM Toronto Lab
Serge,
I am again getting the same error
db2 = call ADMIN.BACKUPSCH EMA('PKMSQA2', '/u01/Backup_schema')
SQL0438N Application raised error with diagnostic text: "EXPORT
raised
error". SQLSTATE=78000
db2 =>
I have checked that everybody has been given read/write/execute
permissions for the directory (/u01/Backup_schema).
What else could be the error?
As I said: permissions are nearly always the reason.
Start the debugger (e.g. Developer Workbench) and walk through it.
You should be able to see the original error and go from there.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Xeon |
last post by:
Hi,
Is there anyway to set a custom error handler which is actually a
method of a class? i.e. setting the method eh() of class foo as error
handler in the snippet below.
class foo {
function eh()
{ do something }
}
|
by: Larry Tate |
last post by:
I am wanting to get those cool html error pages that ms produces when I hit
an error in asp.net. For instance, when I get a compilation error I get an
html error page that shows me the
Description:
Compiler Error Message:
Source Error:
Source File:
The main thing I want is the Source Error. This give me a few lines of the
|
by: p |
last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also
have Crystal 9 pro on my development machine. The web app runs fine on my
dev machine but am having problems deploying. I created the websetup and
built the MSI, have the bundled version. Copied to webserver and ran
Websetup.msi. Said I had to remove old version, which I did, then reran
WebSetup.msi and keeps giving me this error. "The installer was interrupted...
|
by: Binoy |
last post by:
Hello,
I am getting this error once in a while from my web
sites. When I will refresh web browser, it goes off and
sites are working fine.
Directory structures and file names are as below-
C:\WWW - corporate site, C:\WWW\default.aspx is the
default page and this site works fine.
|
by: ranju |
last post by:
I am trying to spawn a process (say an exe file) with different user
crendentials than that of the current user.
1) Called LogonUserEx() to logon the user and recieve a handle to the
token that represents the logged-on user.
2) Called ImpersonateLoggedOnUSer() to let the calling thread
impersonate the security context of logged on user.
3) Used CreateEnvironmentBlock() to get lpEnv
| |
by: JamesB |
last post by:
I am writing a service that monitors when a particular app is started.
Works, but I need to get the user who is currently logged in, and of course
Environment.UserName returns the service logon (NT_AUTHORITY\SYSTEM).
I understand that when the service starts, no user may be logged in, but
that's ok, as the app I am monitoring can only be run by a logged in user.
Do I need to use WMI to get the user context of Explorer.exe or is there a...
|
by: sjambok |
last post by:
I've done it before... on a different site.
Set up all the test enviorns I could... no change, no clue.
No .htaccess to block any transactions.. at least what I could see up to the root level.
Get the following in the url, before even getting to the update /insert coding I'm wanting to do.
(end of coding line.
admin/%3C?BS();?%3E
|
by: Rahul Babbar |
last post by:
Hi,
I am getting the error while trying to take a backup of the schema
according to the backupschema.sql written at
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0602rielau/index.html#download
db2 =CALL ADMIN.BACKUPSCHEMA('PKMSQA','/u01/Backup_schema')
SQL0438N Application raised error with diagnostic text: "EXPORT
raised
error". SQLSTATE=78000
|
by: nickyeng |
last post by:
i calling this piece of java code in jsp :
List<Customer> list = Customer.listby_page(currentRs);
...
...
then it gives me the following error:
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |